SQLDetective 4.7

SQLDetective 4.7 is a powerful and easy-to-use graphic user interface to Oracle databases, which is intended to develop database objects; write and debug stored programs, object types and triggers; execute, analyze and format SQL and PL/SQL statements; administer and monitor databases; compare databases/schemas/objects in the same or different databases, as well as browse and modify data and analyze dependencies between objects.

Release HistoryCompany Flyer
Integrated Development Environment
Main Window

SQLDetective 4.7 is an easy-to-use, highly customizable, multi-session MDI application. The main window's toolbars and child windows can be moved around and resized. The main window and other frequently used child windows automatically remember their size, state and position. Individual toolbars and buttons can easily be hidden and shown. Switch freely between sessions and continue working within the same window, or open a new window. SQLDetective's drag-and-drop coding and other visual editing features simplify development tasks that require numerous editing windows and other open tools in the desktop. Multiple windows are easily managed by taking advantage of the "Show only an active session's windows" and "Fit overlapped windows in workspace" features of the desktop.

Object Navigator

Object Navigator is an integrated window that quickly handles sessions, database objects and configures your workspace. It consists of the following panes: ObjectSelector, ContentSelector, SceneSelector, ColumnSelector and FilterSelector. Object Navigator allows you to: switch between open sessions; navigate, search and view database objects; create, modify, compile and extract database objects; view an object information such as: Data, DDL, Properties, etc.; save, open and easily switch between objects; customize columns and define filters for any dataset; group-process objects; apply filters on tree elements; work with a repository project; view settings and parameters of database instances; display color and graphic object status, and more. Use the Object Navigator window for fast and powerful database browsing, handling and drill-down.

Connection Window

The Database Connection window is used to create a new database session and to call up the Connection Settings window. A new innovation is the ability to assign individual DB types (pre-defined and user-defined) to connections. This feature helps organize your DB connections in groups; e.g. DEVELOPMENT, PRODUCTION, TEST or others. Assign background and foreground colors to easily identify them while working with the content of your mission critical DB's. To increase security while connected to a mission critical DB, you can set "Confirm execution is required…" for statements like "DML (insert, update, delete, PL/SQL block)" and "DDL (create, alter, drop)" for a specified type of a DB.

SQL, PL/SQL and Java Development
SQL Editor

The SQL Editor is a multi-session, multi-page and multi-threaded utility that executes any SQL statement or script, PL/SQL block as well as most SQL*PLUS commands, while supporting bind and substitute variables. Its syntax-highlighting and code folding editor, the integrated Code Insight and Code Assistant eliminates errors while building SQL and PL/SQL statements. SQL Editor provides handy features to execute any SQL statements, browse data, see the plan of execution, statistics, DBMS_OUTPUT and HTML_OUTPUT.

Stored Program Editor

The Stored Program Editor is a powerful editor that offers easy-to-use controls for working with Oracle stored objects. View, create, modify and debug database objects such as: procedures, functions, packages, package bodies, types, type bodies and JAVA sources. Its syntax-highlighting and code folding editors, the integrated Code Explorer and Code Insight eliminate errors while writing stored objects.

Code Analyzer

The Code Analyzer is a code review and quality control tool for Oracle PL/SQL development, built around a code analyzing technology and an advanced code editor. It improves the quality of PL/SQL code while increasing the productivity of the software team; instantly formats the PL/SQL code to a set of code conventions that improve the readability of the software, allowing engineers to understand the new code more quickly and thoroughly; analyses PL/SQL code for the structure and architecture and generates a series of industry standard quality control metrics that identify possible error prone procedures based on complexity, size, modularity and keep the code reliable, testable and manageable. Using the Code Analyzer, users can build PL/SQL code and check it concurrently against a set of rules of industry best practices. It makes the code as clean and efficient as possible.

Code Assistant

The Code Assistant is a powerful utility that helps you write SQL and PL/SQL commands on-the-fly, quickly and accurately. It offers many predefined SQL and PL/SQL statements, supports drag & drop and allows you to write and store your own commands as well.

Code Insight

The Code Insight displays a list of context-related symbols such as: table or view columns, package or type members, schema objects, stored program parameters and variables, in the current scope when you start typing in an identifier. It is integrated with the following SQL and PL/SQL editors: Stored program Editor, SQL Editor.

XML Editor

The XML Editor creates and modifies XMLType columns in datagrids and XML documents. The user can create and modify XML nodes, elements and values using its powerful graphical interface.

HTML Editor

The HTML Editor creates and modifies HTML documents and converts any HTML document into a PL/SQL stored procedure. It offers a set of templates for tables, images, lists, font formats and symbols to facilitate the creation of tags.

Oracle Documentation Browser

The Oracle Documentation Browser is a graphic utility that provides context-dependent access to the HTML Oracle documentation library in the SQLDetective's development environment, for easier and faster access to the requried information. It is fully integrated with the Oracle error processing system.

Database Development
Compare Databases & Schemas & Objects

Compare Databases & Schemas & Objects compares and displays the differences graphically and generates a synchronization script for: two different databases; one or more schemas in the same or different databases; or one or more objects in the same or different databases with the definition of schema and non-schema types and name filters.

Compare Databases compares a Source session with a Target session comparing schema and non-schema objects such as: tables, views, stored objects, triggers, indexes, clusters, roles, users, profiles, directories, tablespaces, rollback segments, resource plans and others. Compare Schemas compares schema objects such as: tables, views, stored objects, triggers, indexes, clusters, etc. in one or more schemas at the same time. Compare Objects compares one or more selected objects. The comparison occurs in the background, without blocking the application, and writes detailed log entries during execution. Set of options, for example, Include Script Comment, Include Object Owner, Include PROMPT and SPOOL allow the configuration of the synchronization script based on user requests.

All user-defined customizations and settings can be saved to a settings file and loaded next session. The comparison result is displayed in a Result Tree indicating the comparison status for each object. Clicking on an object in the Result Tree displays detailed information such as: DDL Differences between objects, Migration SQL, and full Synchronization Script. Copy the synchronization script to the SQL Editor and run it on the Target Session to synchronize the compared databases, schemas or objects.

Schema Extractor

The Schema Extractor is a multi-threaded graphic utility that quickly extracts database schema objects into a file system in the form of SQL scripts - DDLs. It provides a wealth of settings that allows the customization of the information being exported while supporting all database version features. Once obtained, the script is fully compatible with the SQL*Plus program.

Schema Compiler

The Schema Compiler is a multi-threaded graphic interface that quickly compiles invalid database objects and allows you to select engines and compilation types of objects.

Schema Analyzer

The Schema Analyzer is a graphic tool for collecting statistics, validating structures and listing chained rows of tables, table partitions and sub-partitions, indexes, index partitions and sub-partitions and clusters.

Truncate Object

The Truncate Object is a graphic utility that removes rows from a table or cluster.

Find Objects

The Find Objects is a graphic utility that offers an easy-to-use interface to find objects in an Oracle database or Repository matching search criteria. Specify a wide range of settings and search criteria based on the object's name, type, status or contents.

View Differences

The View Differences is a graphic interface that compares database objects, objects stored in Repository as well as combinations of operating system structures amongst themselves.

Fast Copier

The Fast Copier is a graphic utility that is specially designed for fast and easy copying of database objects and data between Oracle databases and schemas.

Analyze Object

The Analyze Object is a graphic utility that analyzes tables, indexes and clusters. It offers easy-to-use controls for computing and estimating statistics, validating REFs and structure of the analyzed object and lists chained rows.

Describe Object

Describe Object is a tool designed to view database objects structures and support for multi-selection. All describing objects open in the same Describe Object window.

Object Properties

Object Properties is a tab of Object Navigator ContentSelector that displays the properties of the selected object in ObjectSelector.

Report Generator

The Report Generator is a multi-session and multi-threaded graphic utility that is specially designed for creating reports in HTML format, based on database objects, table and view data, user privileges, roles, etc. Select a wide range of settings to build a report that meets your needs.

Database Object Wizard

An Object Wizard is a powerful Oracle database version-dependent graphical interface that offers easy-to-use controls for working with Oracle object types. GUI of each wizard depends on the object type, e.g Table Wizard, Trigger Wizard, Index Wizard, etc. On the whole, there are over 30 available wizards in SQLDetective 4.7.

Data Handling
Smart Dataset

The Smart Dataset is a multi-threaded tool that provides facilities such as: browse, insert, edit, delete, look up, filter, sort, group and more, for fast and easy manipulation of tables, views or partition data, without having to write a query, in an intuitively understandable tabulated manner.

CLOB, NCLOB Field Editor

The CLOB, NCLOB Field Editor is a graphic interface that offers an easy-to-use interface for viewing and editing of CLOB (Character large object) and NCLOB (National character large object) columns of a dataset. The powerful editor provides the facilities required for fast and easy manipulation of text data.

BLOB, BFILE Field Editor

The BLOB, BFILE Field Editor is a graphic interface that offers an easy-to-use interface for viewing and editing of BLOB (Binary large object) and BFILE (Binary file) columns of a dataset. The powerful editor provides the facilities required for fast and easy manipulation of binary data.

Nested Table Field Editor

The Nested Table Field Editor is a graphic interface that offers an easy-to-use interface for viewing and editing nested table columns of a dataset.

Object Field Editor

The Object Field Editor is a graphic interface that offers an easy-to-use interface for viewing and editing object columns of a dataset.

REF Field Editor

The REF Field Editor is a graphic interface that offers an easy-to-use interface for viewing and editing REF columns of a dataset.

Varray Field Editor

The Varray Field Editor is a graphic interface that offers an easy-to-use interface for viewing and editing varray columns of a dataset.

Query and Dataset Builder

The Query and Dataset Builder is a powerful graphic tool that provides an easy way to build and test SQL statements such as: SELECT, INSERT, UPDATE and DELETE. This module is used to create and modify user-defined Smart Datasets. Create a visual representation of the data server model with this tool.

Data Dependency Analyzer

The Data Dependency Analyzer is a powerful graphic tool that provides an easy way to view, analyze and modify the dependencies between data, based on the integrity constraints. It accelerates the localization of a data dependency problem.

Export Data

The Export Data offers an easy-to-use interface for exporting data from table or view into SQL INSERT script, Microsoft Excel, XML, PDF, Char Delimited and Internal formats.

Import Data

The Import Data offers an easy-to-use interface for importing data from Microsoft Excel, XML, Char Delimited and Internal formats.

Testing and Debugging
PL/SQL Debugger

PL/SQL Debugger debugs procedures, functions, packages, object types and triggers, step by step. The module provides facilities such as: step into, step out, step over, run to a next exception, watch and edit variables, set breakpoints and more, required to quickly and accurately debug program code on the database server.

TKProf Shell

The TKProf Shell is a utility that greatly simplifies the usage of the Oracle command line utility TKPROF by providing the user with a graphical interface to all of its parameters and options from within the application.

Database Administration
Storage Manager

Storage Manager manages tablespaces, datafiles, segments and quotes in the database instance. It provides an easy to use interface to create, modify, change status, coalesce and drop tablespaces; to create and change the status of datafiles; to relocate and move objects; to create, modify and delete quotes; to show different tablespace information such as: used, free and max size; free space; objects.

Session Navigator

Session Navigator manages sessions in the database instance and is used to view a different session's information such as: open cursors, locks, event waits, long operations, transactions, input and output, statistics etc. It provides a wealth of settings and allows the user to kill and disconnect sessions, and to enable and disable SQL tracing for the selected session(s).

Database Monitor

Database Monitor monitors real-time database performance and displays information such as: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time, Sort Ratio, SGA, Java and Shared Pool, Hit Rates, Recursive Calls, and many others in charts grouped by categories.

The tool supports multi-window and multi-session processing and allows easy monitoring of different oracle sessions at the same time. Easy navigation through the chart categories and properties is available by using the multi-level Page Navigator that is divided from the main monitoring pane by the advanced vertical splitter. The Overview page contains the most important charts from different categories. The list of its charts can be easily changed by using the popup menu and re-ordered using drag&drop. By default, all data collected from the charts is saved to the history file, in the background, to play it back later in the History page for a selected period of time.

The chart alarms control the critical minimum and maximum values of the monitoring parameters and notify the user in a variety of ways such as: alert message box, beep and email. Clicking on the chart displays the detailed tool-tip about the data point. Customize the look and feel and the Record History property of any chart via the popup menu or the Page Navigator. Double click on the chart to maximize it and use the Full-screen mode for closer monitoring. Period of data collection, chart timeframe, scrollbar synchronization, chart grid, the history file size as well as the position of the legend can be customized on the toolbar and in Preferences.

Top Session Locator

Top Session Locator locates the most resource consuming sessions in the database using different activity parameters such as: CPU, Logical I/O, Physical I/O, Parsers, etc.; and Event Waits parameters such as: Concurrency, User I/O, System I/O, etc.

The tool supports multi-window and multi-session processing and allows easy control of resource consumption in different oracle sessions at the same time. Easy navigation through the activity and event wait parameters is available by using the multi-level Page Navigator that is divided from the session list by the advanced vertical splitter. The sessions displayed in the data-grid are sorted by Delta and Cumulative calculated values, so the most resource consuming sessions are displayed at the top of the grid. Sessions using more than <N>% of total value, 20% by default, are highlighted in the data-grid with a different colour that can be customized in Preferences.

Use the predefined and user-defined filters to filter the list of displayed sessions. Advanced Dataset Manager customizes visibility and position of data-grid columns. All user-defined customizations can be saved to a settings file and can be loaded automatically on the next open. Top <N> Sessions, Modules and Users are displayed in pie charts on the Charts tab. Clicking on a segment of the chart locates the session in the data-grid. Displayed information can be refreshed automatically in every defined period or can be refreshed manually.

Database Examiner

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, users, profiles, roles, contexts, directories, database and schema triggers; and resource limits.

The tool supports multi-session processing and allows quick switching between different oracle sessions. Easy navigation through the database properties is available by using the multi-level Page Navigator that is divided from the information pane by the advanced vertical splitter. Instance options, initialization and NLS parameters, Resource Limits, System events and statistics and the list of users, profiles, roles, contexts, etc. are displayed in powerful data-grids that allow sorting (local, server), filtering, exporting to different formats, and customizing column width, position and visibility. These powerful data grids are provided by the advanced Dataset Manager. The advanced Dataset Manager is divided from Information pane by the vertical splitter. Displayed information can be refreshed automatically in every defined period or can be refreshed manually.

Support for RAC instances

Oracle RAC — Oracle Real Application Clusters — is a technology that allows multiple database instances that work on different servers to access a single Oracle database. SQLDetective 4.7 allows working with databases that include RAC instances, i.e. viewing details for each available RAC instance (instance ID, number, name; host name; version; startup time, etc.), building queries to retrieve information about RAC instances using G$ views, etc..

RAC instances are available in the following modules: Object Navigator, Session Navigator, Database Examiner, Database Monitor, Top Session Locator.

Object Privileges

The Object Privileges is a powerful graphic interface that offers easy-to-use controls for working with Oracle object privileges. View, grant and revoke access to database objects. Administer any database object quickly and accurately with this tool.

Repository and Version Control System
Repository and Version Control System

Repository and Version Control System provides instant access to frequently-used database objects, user-defined Smart Datasets, SQL statements, PL/SQL and JAVA code templates and any other text information. The powerful built-in and third-party version control systems such as Microsoft Visual Source Safe, Merant PVCS and others that support Microsoft SCC API, allow for save and control of object versions. The built-in version control stores its projects in the Repository manages your individual and team projects more easily than ever before!

Online Support Desk (OSD) — Contact us & Update software

OSD — Online Support Desk — is a built-in tool that gives SQLDetective users an easy way to automatically update the software (OSD Updater) and directly contact Technical Support (OSD Messenger) for help*).

*) Please be aware that customers with AMS (Annual Maintenance & Support) coverage benefit from priority technical support and guaranteed minimum response time to their OSD and email messages. The support team commits to a response within 2 business days at the latest. In general, help can be provided much more quickly. AMS customers also benefit from software updates and new version releases at no additional cost.

Icon Dictionary

The Icon Dictionary is a new, unique and safe method to browse all Icons, learning their functions without any risk of unwanted function execution or process creation. Navigate and browse all Icons/Buttons through its logical tree structure, In Education mode, all icons are inactive, making it possible to click on them without executing their functions. When clicked, the Icon is automatically displayed in its window, showing a "Hint" and related quick help message.
In addition, it is easy to see if a Shortcut key is available for a specific Icon and to customize this Shortcut to suit individual preferences. Its Movie Navigator gives you ability to administer, navigate and display educational movies that help to learn the application quickly and easily.

Macro Recorder

The Macro Recorder quickly and easily records and plays back a set of keystrokes, mouse movements and clicks. Macro is used to automate and dramatically reduce time for resolving specific repetitive tasks.

Oracle E-Business Suite Object Description

The Oracle E-Business Suite Object Description is a special utility that quickly accesses the Oracle*E-Business Suite object description in the SQLDetective's development environment. This unique utility is specially developed for Oracle*E-Business Suite CIS implementation and support staff.