SQLDetective 4.3	ClearSQL 5.6	ClearDB 2.5

SQLDetective supports demand features of Oracle 7.3 - 11.1 and provides all the facilities required to:

Quickly develop any type of the following database objects using Visual Object Editors:   Tables - relational, object, index-organized, partitioned (range, hash, composite, list), temporary, clustered, external and XML       Table (view) columns - built-in (Char, Varchar2, Number, Date, Interval, etc.), LOB (BLOB, CLOB, NCLOB, BFILE), user defined (Object type, Nested table, Varray, REF) and XMLType   Integrity constraints - primary key, unique key, foreign key, check   Views - standard, object and XML   Triggers - table, view, schema, database   Indexes - non-unique, unique, bitmap, clustered, joined, partitioned, functional   Clusters - index and hash organized   Collections, Sequences, Jobs, Policy, Index types, Operators, Libraries, Database Links, Synonyms, Contexts, Directories, Profiles         Easily write, test, debug and execute server-side programs:     Procedure, Function, Package, Package Body, Type, Type Body, Java Source, HTML-based program using powerful syntax highlighting PL/SQL, JAVA and HTML Editors   Customizable Code Assistant, Integrated Code Insight and Code Explorer and drag-and-drop eliminates errors and decreases development and test time   Execute SQL scripts, PL/SQL subprograms, stored programs and SQL*Plus commands over multiple concurrent database sessions quickly with the multi-threaded SQL Editor     Debug stored programs step-by-step over multiple concurrent database sessions easily with PL/SQL Debugger     View execution plan of SQL statements hierarchical on the database with the Explain Plan feature     Format and improve the quality of PL/SQL code using a code review and quality control tool for Oracle PL/SQL development - ClearSQL for SQLDetective     Learn more about the Oracle database and find answers to any database-related questions, using the Oracle Documentation Browser, without leaving IDE       Conveniently browse, modify, search, sort and export any type of data:       Insert, edit, and delete records quickly with visual access to information in tables and views using Smart Dataset. Turning the Show constraints in the caption setting on, Smart Dataset accelerates the browsing and modification of foreign key related data     Execute complex queries over multiple concurrent database sessions and immediately view result sets, supporting bind and substitute variables with SQL Editor     Browse, search, sort and group data without having to write a query, using the QBE (query by example) interface to data in the Dataset Editors     Build complex datasets without having to write a query, using the graphic interface provided by Dataset Builder     Analyze and modify dependencies between data, based on integrity constraints, using a powerful master-detail browser provided by Data Dependency Analyzer     Represent the server data model and create, on its basis, a query of any given complexity in the graphical Query Builder     View, insert and modify complex data types such as: BLOB, CLOB, NCLOB, BFILE, Object Type, Nested Table, Varray, XMLType and REF in the powerful Visual Field Editors       Smart manage schemas and database objects using such tools as:       Schema Extractor - extract schema objects into a file system in the form of SQL scripts (DDL)     Schema Compiler - compile invalid database objects and select engines and compilation object types     Schema Analyzer - collects statistics, validates structures and lists chained rows of tables, table partitions and sub-partitions, indexes, index partitions and sub-partitions and clusters     Fast Copier - copy database objects and data between Oracle databases and schemas     Find Objects - find objects in the Oracle database or Repository matching search criteria     Report Generator - create reports in HTML format, based on database objects, table and view data, user privileges, roles, etc       Simpler administration and monitoring of databases using such tools as the:       Session Navigator - manages sessions in the database instance the user is currently connected to, and displays a different session's information     Storage Manager - manages tablespaces, datafiles, segments and quotes in the database instance     Database Monitor - monitors real-time database performance and displays information such as: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, and many others in charts     Top Session Locator - locates the most resource consuming sessions in the database using different parameters such as: CPU, Logical I/O, Physical I/O, User I/O, System I/O, etc     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, etc     TKProf Shell - 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     Tablespace Wizard - a powerful Oracle database version-dependent graphic interface that offers easy-to-use controls for viewing, creating and modifying tablespaces

Conquest Software Solutions offers powerful kits to extend the reach of SQLDetective. They provide intelligence and optimize PL/SQL server-side development, Oracle-based applications maintenance and database administration.