The following list describes the main features of OraDeveloper Studio.

Feature Map

• 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 navigatable Document Outline panel
  • Extensive collection of SQL code templates
  • Full history log stores all executed queries
  • Quick SQL history navigation
  • SQL file Navigation bar lists created database objects and subobjects
  • Code Bookmark support

• PL/SQL and Script Debugging
  • Can debug 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

• 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
  • Visually create all types of JOINs
  • Advanced tabbed editor with full SELECT statement clause support
  • Integrated with Database Explorer

• Extended SQL Execution Features
  • Supports the following SQL*Plus commands: @, @@, ACCEPT, CLEAR, CONNECT, DEFINE, DESCRIBE, EXECUTE, PROMPT, REMARK, VARIABLE
  • Can execute files, stored procedures and functions, and selected code fragments
  • Analyze 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
  • Supports Text, HTML, XML, and MS Excel file formats
  • Customizable export document appearance attributes
  • Can export entire grid or selected rows and columns

• Database Export/Import
  • Based on native Oracle Export and Import 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 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

• Convenient User Interface
• Tabbed document interface with supported tab groups
• Highly customizable layout
• Dockable tool windows with auto hide and floating
• Documents with different views
• Customizable toolbars
• Comprehensive Help System
  • Background material and Tutorials help you get started quickly
  • Context help for every window and tab
  • Detailed reference material for every OraDeveloper component
  • Clean Help interface with separate Contents, Index, and Search