|
OraTools is a simple, lightweight application for manipulating Oracle data and schema objects. With OraTools you can
execute, verify, and optimize your SQL and PL/SQL statements, navigate
and view properties of schema objects, and debug stored procedures.
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.
OraTools is available as a standalone application and as an add-in for
use with ODAC.
Note: This product is no longer being developed. It has been replaced with the OraDeveloper Studio and Tools product line. Details
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 highlighting for PL/SQL statements
- Customizable history of SQL statements
- Data-aware grid with filter and search options and navigation controls to simplify 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
Related Products
OraTools is an ancestor of the OraDeveloper product line and
is no longer being developed. If you would like to have access to more database development functionality, we suggest you try out OraDeveloper Studio and OraDeveloper Tools, our new database development tools for Oracle. For more information, see the following pages:
| 
