OraEdit PRO is an editor and debugger for Oracle PLSQL source code. With OraEdit PRO, code can be edited and compiled directly from the database.
Any PL/SQL object, including triggers, packages, procedures and functions, can be run in the OraEdit PRO Debug(TM) mode, with all variables available for view. Runtime value changes are supported. OraEdit PRO includes a powerful Code Completion engine (IntelliSense) that assists in object editing and creation by providing floating lists with keywords, objects, and fields. An advanced Tip feature proposes words based on the current activity. OraEdit PRO also provides assistance using packages, procedures and functions by providing a floating window marking the required parameters and types, as well as highliting the current parameter.

The OraEdit SQL Worksheet allows you to execute any sql statement and examine the results in a grid. Any DML (data manipulation language) scripts can be executed in this fashion, as well as DDL (data definition language) scripts.

OraEdit also provides a Table Browser that allows you to view all records within any specific table, you can also manipulate the retrieval of records using filters, as well as updating and inserting records directly from the grid.

OraEdit PRO includes pre-defined interfaces to External Version Control systems, allowing easy Check In, Check Out, Lock, Unlock, Add, Remove and Labeleling of source code directly from OraEdit PRO. Additional features are provided, including advanced database search, object export, objects comparisons, object dependency views (both Uses and Used By), and quick compile of all invalid objects. OraEdit PRO supports the simultaneous use of multiple databases.
 

• Automatic Code-Completion
• Function/Procedure prototype tips
• Keyword and object tips
• Execution of Objects
• Enable/Disable of Triggers
• Full blown debugger
• Table Browser (data)
• SQL Worksheets
• Auto-compilation of dependencies with debug information
• Interface to your favorite Source Control system
• User-definable keywords
• Syntax coloring
• Search in database
• Compare objects within the same and other databases
• Multiple database editing simultaneously
• Workspace management
• Export source code/generate sql scripts
• Compile all invalid objects
• Object templates for easy creation of new objects
• Favorites menu to quickly access objects

• As you type OraEdit PRO will suggest words that match what you are typing.
• When accessing a table/view, OraEdit PRO will provide a list with available fields.
• Automatic generation of anonymous blocks for executing or debugging purposes.
• Debugger with step into, step out of, step over, run and breakpoint support.
• Unlike other tools, breakpoints can be set long before execution and will persist through debugging sessions.
• While debugging, just "hover" over a variable and see a tip with the current value.
• You can define your own keywords for OraEdit PRO to suggest as you type.
• OraEdit PRO can display all available functions/procedures within a package for easy access, even if they are not defined in the package header.
• Automatically toggle from error to error while highlighting "offender"
• After searching database, click on the results and it opens the object on the correct line.
• Compare objects in different databases, even files.
• If any database gets disconnected, it will connect back without "bugging" you.
• Get notified when someone else changes the same code you are editing, thus preventing overwriting others code.