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

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 though 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 program quickly and easily.

The Online Support Desk is a powerful utility that provides the user with an easy-to-use graphical interface to communicate with Technical Support , receive news from Conquest Software Solutions and keep SQLDetective and its kits up-to-date using the auto-update feature.

The Macro Recorder quick and easy 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.

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

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.

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.

ClearSQL for SQLDetective 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 ClearSQL for SQLDetective, 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.

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.

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.

The Report Generator is a multi-session and multi-threaded graphic utility tahtis 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.

Table Wizard

The Index Wizard is a powerful Oracle database version-dependent graphic interface that offers easy-to-use controls for working with Oracle indexes. View, create and modify: non-unique, unique, bitmap and partitioned indexes for a tables, clusters or joined tables. Develop any type of index quickly and accurately with this tool.

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

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.