OraDeveloper Tools Features

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 Embarcadero RAD Studio

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

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

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

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

Enhanced SQL Editor

• Syntax highlighting
• Context-sensitive code completion and parameter information
• Mouseover quick info for database objects
• Code outlining integrated with Document Outline navigation 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

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
• Navigation Call Stack

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

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

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

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

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

Database Export/Import

• Based on native Oracle Exp and Imp utilities
• Friendly user interface
• Different export modes
• Advanced database import features

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

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

Flexible Connectivity

• Support for all Oracle versions from 8i 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

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

Comprehensive Help System

• Context help for every window and tab
• Detailed reference for every OraDeveloper component
• Tutorials that help you get started quickly