OraDeveloper Tools for Delphi 2.55.168

OraDeveloper Tools for Delphi 2.55.168 is written to be an efficient and reliable add-in which enables you to simplify the Oracle database application development process. It integrates into Visual Studio and Delphi, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.

Benefits:

1. Integration with the most popular IDEs
   • OraDeveloper Tools brings Oracle development and administration power to the newest development environments from Microsoft and CodeGear.
   • Microsoft Visual Studio 2008
   • Microsoft Visual Studio 2005
   • Microsoft Visual Studio .NET 2003
   • Delphi and C++Builder 2010
   • Delphi and C++Builder 2009
   • CodeGear RAD Studio 2007
2. Collaboration with Oracle data access libraries
   • Drag database objects from DbExplorer to create preconfigured connection, data adapter, or command objects of the following products:
   • • dotConnect for Oracle Data Provider
     • MS OracleClient
     • ODP.NET
     • OLE DB Data Provider
     • Oracle Data Access Components
   • OraDeveloper Tools provides some special features for dotConnect for Oracle Professional Edition. Due to OraDeveloper Tools dotConnect for Oracle gains enhanced component designers, which are extended with additional commands. The commands provide easy access to useful operations such as opening query builder, SQL editor, or any object editor that can assist you in current situation.
3. Integration with dotConnect for Oracle
   • OraDeveloper Tools provides some special features for dotConnect for Oracle Professional Edition. Due to OraDeveloper Tools dotConnect for Oracle gains enhanced component designers, which are extended with additional commands. The commands provide easy access to useful operations such as opening query builder, SQL editor, or any object editor that can assist you in current situation.
4. Convenient Server Browsing
   • Navigating through databases has never been easier. An integrated Database Explorer window lets you effortlessly browse the entire server hierarchy. With one-click access to data and property views, you can reach, view, and modify all database schema objects in seconds. Database Explorer displays database object dependencies for easy finding of depending objects, and stores user browsing history for easy returning to visited objects and folders. OraDeveloper Tools allows you to search for database objects in selected schemas by name. You can also search for PL/SQL code in source objects and locate data in tables, views, and materialized views.
5. Simple Object Creation and Modification
   • With OraDeveloper Tools you will no longer need to spend hours manually modifying database structure. OraDeveloper Tools automates routine tasks and makes common database operations easily accessible. You can create and duplicate schema objects directly from the Database Explorer and visually modify objects, add constraints, and set triggers with a set of powerful objects editors. Object editors are optimized for efficient database interaction and feature intuitive and user-friendly layouts. Moreover, OraDeveloper Tools gives you full control of the database engineering process and lets you view the DDL statements of each schema object and generate and edit DDL scripts for multiple database objects.
6. Database Project Support
   • OraDeveloper Tools comes with an extensive project management system that you can use create database projects and integrate related database development files. Database project units make it easer to manage large development projects and automate routine database maintenance tasks. You can use the Solution Explorer to bookmark and integrate separate scripts, query files and favorite database objects into projects, work on them from a single workspace, compile source objects, and easily deploy entire project batches, specifying the order of execution. With New Database Project Wizard you can easily create a new project or import an existing schema to a new project.
7. Advanced SQL Handling
   • Enhanced SQL editor provides many useful features to make the development process easier. It simplifies SQL scripting by highlighting syntax as you type and helps you write queries with context-sensitive code completion and parameter information features for both scripts and single statements. Moreover, a separate SQL history keeps track of which SQL statements you have run and stores them so you can recall any of them once you need it. OraDeveloper Tools contains a number of most frequently used code examples to use in your SQL scripts or stored routines. Document Outline window shows opened SQL document logical structure. It can be used to view document elements and navigate to them. Navigation bar eases navigation between DDL statements. Any SELECT statement in a script or PL/SQL object can be visually designed with Query Builder. Advanced Visual Query Builder makes it possible to build even the most complicated queries without typing a single line of text. OraDeveloper Tools also supports some SQL*Plus commands.
8. PL/SQL and SQL Script Debuggers
   • With OraDeveloper Tools, you can debug all Oracle source objects with a built-in PL/SQL Debugger and perform step-by-step execution of SQL commands with an integrated SQL script debugger. OraDeveloper Tools lets you set breakpoints to stop execution on any line of code. It includes a Call Stack window for viewing the currently active stack of PL/SQL program and a Watches window and evaluating and modifying program variables.
9. Database Administration Tools
   • OraDeveloper Tools features a powerful database administration toolkit, including Security and Session Managers and Schema Import and Export Wizards. Security Manager allows you to perform the full range of database security administration tasks such as manipulating users, granting and revoking roles and privileges, managing profiles. Session Manager lets you control user sessions and watch their information.
10. Powerful Data Editing
    • Grid-based Data Editor has everything you might require when inspecting and editing data. You can filter, group, and sort data in-place, as well as customize the grid, cache updates on client, or control data manipulation with connection-level transactions. A separate LOB Viewer and LOB Editor allow you to view and edit field values that contain binary and long text data.
11. Easy Data Export
    • You can export all the selected data or only specific rows and columns. Data export wizard helps you export data to Text, HTML, XML, and MS Excel file formats. Before exporting you can customize export style attributes, such as text, background and border color, font, and set output format of exported columns.
12. Flexible Database Backup and Restore
    • Use the Export Utility Wizard to back up part or all of a database in binary format. The versatility of native Oracle Exp and Imp utilities is now available in a short sequence of user-friendly dialogues. Import Utility provides you a very easy database restoring from previously exported file.
    • Schema Export Wizard allows you to extract schema to script. You can extract any database objects metadata, extract data from all or selected tables, set different extracting options, which affect the result script. Schema Import Wizard provides you a very easy schema restoring from a script.
13. Wide Oracle Server Support
    • Support all range of Oracle servers from 7.3 to 11g.
14. Direct Access to Oracle Server
    • OraDeveloper Tools does not require Oracle client software installed and can communicate directly with the Oracle server.
      

Major Features:

1. Full Development Environment Integration
   • All database development and administration tasks available from your favorite IDE
   • SQL Editor, database object editors and other editors behave like usual IDE documents
   • Help integrated into Microsoft Visual Studio .NET and Borland Delphi
2. Component Designers' Extended Capabilities (for dotConnect for Oracle Professional Edition)
   • New verbs to access useful features
   • SQL Editor, Query Builder, all of Object Editors to facilitate your work
3. Convenient Server Browsing
   • Multiple simultaneous connections
   • Quick invocation of object editors
   • Single-click access to object properties
   • Full object search
   • Dynamic data viewing
   • Database object dependency support
   • Browsing history
4. Easy Database Object Manipulation
   • Convenient and easily accessible visual editors for all objects
   • Visual design and text modes
   • Generatable DDL scripts for database objects
   • Duplication of database objects
   • Changes are cached until you apply them
   • Comment support for tables, views, materialized views, table and view columns
   • Undo option
5. Database Project Support
   • Project Explorer workspace for organizing related database objects and scripts into a single project
   • Easy project deployment
   • Workspace saving
   • Convenient document control
   • Project PL/SQL programs compilation
   • Ability to export an entire project into a file
   • Ability to export a project into an SQL*Plus script
6. Enhanced SQL Editor
   • Syntax highlighting
   • Context-sensitive code completion and parameter information
   • Mouseover quick info for database objects
   • Code outlining integrated with navigatable Document Outline panel
   • Extensive collection of SQL code templates
   • Storage of all executed queries in full history log
   • Quick SQL history navigation
   • Display of created database objects and subobjects on SQL file Navigation bar
   • Code Bookmark support
7. PL/SQL and Script Debugging
   • Debugging of stored procedures and functions, object types, packages, triggers, and SQL scripts
   • Step into, step over, run to cursor and breakpoint support
   • Support for evaluating and modifying variables
   • Navigatable Call Stack
8. Advanced Database Administration Tools
   • Security Manager for manipulating users, roles, user profiles and privileges
   • Session Manager for controlling sessions
   • Event Monitor for watching and sending Oracle alerts and pipe messages
9. Visual Query Builder
   • Powerful interactive query construction
   • No need to type a line of code to compose a query
   • Visual creation of all types of JOINs
   • Advanced tabbed editor with full SELECT statement clause support
   • Integration with Database Explorer
10. Extended SQL Execution Features
    • Support of the following SQL*Plus commands: @, @@, ACCEPT, CLEAR, CONNECT, DEFINE, DESCRIBE, EXECUTE, PROMPT, REMARK, VARIABLE
    • Execution of files, stored procedures and functions, and selected code fragments
    • Analysis of query performance with the Plan tool
    • Script support
    • Asynchronous execution
11. Powerful Grid-Based Data Editor
    • Highly customizable
    • In-place filtering, sorting, and grouping
    • Paginal mode
    • Separate LOB Editor for viewing and updating simple binary objects and long text
    • Transaction mechanism for data manipulation control
    • Client-side caching
    • Data printing
    • Graphic card view
12. Easy Data Export
    • Support of Text, HTML, XML, and MS Excel file formats
    • Customizable export document appearance attributes
    • Export of entire grid or selected rows and columns
13. Database Export/Import
    • Based on native Oracle Exp and Imp utilities
    • Friendly user interface
    • Different export modes
    • Advanced database import features
14. Customizable Schema Export/Import to/from SQL
    • Extracting of any supported schema object
    • Data extracting from selected or all tables
    • Different extracting options
    • Advanced schema import features
15. User-friendly Object Editor for Every Supported Schema Object
    • Table
    • View
    • Index
    • Unique key
    • Foreign key
    • Check constraint
    • Package
    • Stored procedure
    • Stored function
    • Trigger
    • User type
    • Sequence
    • Materialized view
    • Materialized view log
    • Synonym
    • Cluster
    • Database link
    • XML schema
16. Flexible Connectivity
    • Support for all Oracle versions from 7.3 to 11g
    • Ability to use several Oracle Homes in single application
    • Instant Client support
    • Optional direct access mode for establishing connections without Oracle client software
17. Convenient and Flexible User Interface
    • Tabbed documents
    • Documents with different views
    • Documents tab groups
    • Highly customizable layout
    • Dockable tool windows with auto hide and floating
    • Customizable toolbars
18. Comprehensive Help System
    • Context help for every window and tab
    • Detailed reference for every OraDeveloper component
    • Tutorials that help you get started quickly