OraTools key features:

• Consistent and user-friendly interface
• Single database connection
• Common login prompt
• Inter-utility transaction tracking

OraTools consists of four utilities: OraDesigner, OraExplorer, PL/SQL Debugger, and OraBuilder.

OraDesigner

OraDesigner lets you execute SQL statements, anonymous PL/SQL blocks, call stored procedures and parameterized queries. It is useful for building, testing and optimizing SQL and PL/SQL statements and for creating and modifying database objects and schemas. OraDesigner enables you to manipulate SQL commands and PL/SQL blocks, and to perform many additional tasks as well.

OraDesigner includes the following SQL development and execution features:

• Syntax highlight for PL/SQL statements
• Customizable history of SQL statements
• Data-aware grid with filter, search options, and navigation controls to simplify the result set interpretation
• Load/save for SQL script files
• Execution plan for SELECT statements
• Data editing capability

OraExplorer

OraExplorer is an easy-to-use browser for schema objects and database metadata information. Names of objects are organized into a hierarchical tree view. Selecting tree branches updates information pages with details about associated objects.

PL/SQL Debugger

PL/SQL Debugger reveals the normally hidden flow of PL/SQL statements as they are processed by Oracle server. Step-by-step execution lets you stay informed about what actually takes place inside your program execution. Includes support for stepping into stored procedures and functions.

PL/SQL Debugger includes the following standard debugging features:

• Step into, step over, step out
• Set/remove breakpoints
• Watch variables
• Evaluate/modify variables
• Call stack list

OraBuilder

OraBuilder is a simple visual interface for building queries. OraBuilder presents the database objects involved in a query and lets users visually manipulate the joins between them. It offers the ability to adjust selection list, criteria, joins, groups, group criteria and the chosen sorting list.

OraBuilder includes a database object tree and lets you edit SQL statements in both diagram and text mode. Results of the executed query can be viewed in both grid and SQL formats and can be copied to the clipboard with a single mouse click.

OraBuilder features:

• Database object tree
• Diagram and text modes for editing SQL statements
• Grid and SQL formats for viewing query results
• Single-click copying of query data to clipboard