OraDeveloper Studio 2.2 Screenshot

OraDeveloper Studio is a powerful development environment for Oracle.

OraDeveloper Studio shows a clean interface for browsing databases, creating and modifying schema objects, visually designing queries, updating data and developing SQL scripts and PL/SQL program units.

OraDeveloper emphasizes a visual approach to database interaction and speeds up your database developments with a powerful collection of SQL, object, and data editors. All components are deeply integrated with a Database Explorer for streamlined database navigation and development. IDE features a project management framework for singling out and organizing related server objects and scripts into easily accessible projects.

OraDeveloper Studio is a standalone application that runs with .NET Framework 1.1 or 2.0. OraDeveloper Studio is compatible with Oracle 8.0, 8i, 9i, and 10g and supports both client and direct access connection modes.

Also available as OraDeveloper Tools, a set of add-ins for Visual Studio and Delphi.

Here are some key features of "OraDeveloper Studio":


Convenient Server Browsing
· Multiple simultaneous connections
· Quick invocation of object editors
· Single-click access to object properties
· Full object search

Dynamic data viewing

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
· 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

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
· 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
· 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 Exp and Imp utilities
· Friendly user interface
· Different export modes
· Advanced database import features
· User-friendly Object Editor for Every Supported Schema Object
· Table
· View
· Index
· Unique key
· Foreign key
· Check constraint
· Synonym
· Sequence
· Stored procedure
· Stored function
· Materialized view
· Materialized view log
· Package
· Trigger
· User type
· XML schema

Flexible Connectivity
· Support for all Oracle versions from 7.3 to 10g
· Ability to use several Oracle Homes in single application
· 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