OraDeveloper Studio 2.50

OraDeveloper Studio 2.50 offers you an excellent and very useful software which is a comprehensive IDE for professional Oracle developers. OraDeveloper Studio gives you a powerful interface for browsing databases, creating and modifying schema objects, updating data, visually designing queries, and developing SQL scripts and PL/SQL program units.

OraDeveloper Studio emphasizes a visual approach to database interaction and speeds up your database developments with a powerful collection of SQL code, schema object, and data editors. All components are deeply integrated with a Database Explorer for streamlined database navigation and development. OraDeveloper Studio is compatible with Oracle 8.0, 8i, 9i, and 10g and supports both client and direct access connection modes.

Major Features:

1. 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
2. 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
3. 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
4. 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
   • Display of created database objects and subobjects on SQL file Navigation bar
   • Code Bookmark support
5. PL/SQL and Script Debugging:
   • Ability to 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
6. 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
7. 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
8. Extended SQL Execution Features:
   • Support 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
   • Provides asynchronous execution
9. 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
10. 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
11. Database Export/Import:
    • Based on native Oracle Export and Import Utilities
    • Friendly user interface
    • Different export modes
    • Advanced database import features
12. 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
13. 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
14. 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
15. 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
16. 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

• Advanced context-sensitive code completion
• SQL*Plus command support
• Fully customizable keyboard mapping schemes
• DDL generation extended with high number of options
• Clusters and database links supported
• Database object dependency supported
• Database object search extended with full-text mode

Requirements:

• .NET Framework 1.1 or 2.0.
• 800 MHz or higher processor
• 512 MB RAM
• 20 MB of free hard disk space
• Microsoft Windows 2000/XP/2003