SQLDetective 4.7

SQLDetective 4.7 is a comprehensive development solution that accelerates the development, implementation, administration and maintenance of Oracle-based applications.

Release HistoryCompany Flyer


SQLDetective 4.7 is a powerful and easy-to-use graphical user interface to Oracle databases. It provides an integrated environment for developing database objects, writing and debugging stored programs, executing and testing SQL and PL/SQL commands, as well as searching and modifying data and analyzing the dependencies between the objects. Visual object editors allow users to quickly create and modify database objects such as: table, view, trigger, index, job, cluster, synonym, operator, etc depending on the features of the Oracle database versions. Syntax highlighting and code folding Code Editors, Code Helper, Code Insight and Integrated Oracle Documentation Browser allow the user to write procedures, functions, packages, object types, triggers and JAVA in a high quality and error free way. Object Navigator facilitates easy navigation of database structures by displaying database schema objects and their relationships in an intuitive hierarchical interface.


SQLDetective 4.7 is a range of handy utilities to tune SQL scripts, test PL/SQL statements, write and execute stored programs, debug stored objects step-by-step. SQL Editor executes SQL and PL/SQL statements supporting bind and substitute variables. The advanced Stored Program Editor offers an easy-to-use interface for writing and executing stored programs. The fully integrated PL/SQL Debugger offers all features that a user could wish for: step over, step into, step out, run until exception, break execution, set conditional breakpoints, view and modify scalar and complex variables and more, to debug stored procedures, functions, packages, type bodies and triggers on a database server. Format and improve the quality of PL/SQL code using the Code Analyzer - a code review and quality control tool for Oracle PL/SQL development.


SQLDetective 4.7 empowers DBAs with the powerful and easy to use administrative and monitoring tools and utilities such as: Database Examiner provides easy access to database information such as: database system; instance options; initialization and NLS parameters; system events and statistics; SGA memory allocation; list of sessions; tablespaces, datafiles, rollback segments, etc.; Database Monitor monitors real-time database performance and displays: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time, Sort Ratio, SGA, Hit Rates, Recursive Calls, and many others in charts grouped by categories; Top Session Locator locates the most resource consuming sessions in the database using different activity and Event Waits parameters such as: CPU, Logical I/O, Physical I/O, Parsers, Concurrency, User I/O, System I/O, etc.; Storage Manager manages tablespaces, datafiles, segments and quotes in the database instance; Session Navigator manages sessions and displays information on different sessions. The application also provides the ability to work with Oracle Real Application Clusters (RAC) databases.


SQLDetective 4.7 is a complete environment for handling data. Dataset Editors allow users to quickly browse, search, modify, analyze and export&import scalar, object table, collection, REF and LOB types of data. Utilize advanced Export and Import Data utilities to export and import scalar and complex types of data into a number of popular formats like SQL INSERT Script, SQL MERGE Script, Microsoft Excel, XML, PDF, HTML, Char Delimited, etc. The powerful Dataset Builder allows users to create complex datasets without having to write a query. The Data Dependency Analyzer provides a graphic environment to represent and modify the referring data based on integrity constraints. The graphical Query Builder allows users to represent the server data model and create a query of any given complexity, on its basis.


SQLDetective 4.7 features a fast, easy-to-use environment that allows users to customize the workspace and visual tools on request. The Oracle Client Interface (OCI) allows users to utilize all database benefits and dispenses with the installation of additional drivers (e.g. ODBC or JDBC) in user's workstation.