OraTools site license OraTools is a simple, lightweight application for manipulating Oracle data and schema...
Download

OraTools site license Ranking & Summary

OraTools site license Tags

manipulating

OraTools site license Description

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

OraTools site license Related Software