OraTools

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. 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