SQL Assistant for Oracle

SQL Assistant for Oracle 2.2.0

Abilities of the SQLaps SQL Assistant for Oracle: 1) Supports the Oracle Server version - 8i/9i and 10g support HAS BEEN ADDED! 2) SQL Editor allows execute SQL statements in the separated threads (parallel execution of the long-time queries), scripts and PL/SQL blocks,preview the explain plan, export data to text and SQL*Loader control files, use the code completion and queries history for quick return to the earlier executed statements. 3) Extract DDL Wizard allows to extract schema objects and generate SQL script for these objects. 4) Management of the Schemas,Functions,Procedures,Packages,simple and partitioned Tables,Indexes,Constraints,Views, Triggers. 5) Security management (Creating and management roles and profiles, grant and revokes privileges. Creating and management the users accounts, the checking and recompile the invalid objects). 6) Sessions management, SQL monitoring, start/stop sessions tracing, and show results. 7) Management of the Redologs and Tablespaces. (Creating and checking redogroups,redologs files, management tablespaces, management and resizing datafiles) 8) Improved, useful and fast interface for the Oracle Logminer (view/run stored statements for the executed transactions (redo- and archivelogs)), no additional installations require. (Simple and fast analyze of the redo/archivelogs). 9) Preview/save the images into the BLOB/CLOB fields from clipboard. You can download 30-days trial version of S.Q.Lap's SQL Assistant from links at http://sqlap.fortunecity.com/ You can find the detail description of application in the users manual (sqlapmanual.doc in the ZIP-archive). Please write your questions and suggestions to sqlapsqlassistant@yahoo.com Thanks for attention, The SQLap's SQL Assistant Developers team.

Download SQL Assistant for Oracle

Home