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
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 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 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
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.
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.
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.
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 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.
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
development environment, for easier and faster access to the requried information.
It is fully integrated with the Oracle error processing system.
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.
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.
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.
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.
The Truncate Object is a graphic utility that removes rows
from a table or cluster.
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.
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 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.
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 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 is a tab of Object
Navigator ContentSelector that displays the properties of the selected object
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
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.
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.
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.
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.
The Object Field Editor is a graphic interface
that offers an easy-to-use interface for viewing and editing object
columns of a dataset.
The REF Field Editor is a graphic interface
that offers an easy-to-use interface for viewing and editing REF
columns of a dataset.
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.
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
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.
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 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.
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.
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 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 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.
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.
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.
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
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
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.