OraSphere: Query Master

Query Master is a multi-threaded SQL and PL/SQL tool with a script library and an advanced grid for developers, analysts and DBA. With Query Master you can build and execute queries, create database objects and develop SQL and PL/SQL code. It simplifies day-to-day administration tasks, data exporting and reporting from grid.Script library Allows to use the existing or make your own major script library. Made as an easy usable tree with drag-and-drop functions and preview option. SQL & PL/SQL editor An improved text editor for most SQL and PL/SQL statement creation, with syntax highlighting, pop-up window with database objects, formatting and other features. Statement execution Runs SQL showing the result in Grid. Runs a script showing the results in Script Output with DBMS_OUTPUT support. Runs for update. Support for bind variables. Commands EXECUTE and DESCRIBE. Powerfull grid Single-click local sorting, custom filtering and drag-and-drop column grouping. Data edition, export and printing. Script import Script or script directory importing into a new or existing script librabry. Execution Plan Possibility to view an execution plan for SQL statement. Multi-threaded Possibility to use program, while one or more SQL, PL/SQL are executing, and save changes or break execution at any time. Transaction queue It processes transactions of a session one by one. While one transaction (SQL, PL/SQL statement) is executing, the next are inserted in the queue. When the executing transaction is finished or stopped, processing of the next transaction will start automatically. Oracle home selector Select the Oracle client which will be used to connect to a data base, if it differs from the default Oracle home. Easy installation No other middle-ware required other than Oracle SQL*Net. No database object installation required. A simple installation procedure enables to use the tool.