OraTools Overview

OraTools is a free, 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
  • Free of charge

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: 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 dbForge Studio for Oracle and OraDeveloper Tools, our new database development tools for Oracle.

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
OraTools - OraDesigner

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.

OraTools - OraExplorer

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
OraTools - PL/SQL Debugger

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