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

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 and more...
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 - the Code Analyzer Kit for SQLDetective 4.3


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, filter and export&import any type of dаta:

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

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.


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:

Compare Databases - 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


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

Home:

http://www.sqldetective.com/

[/b]

[b] Only for V.I.P

Warning! You are not allowed to view this text.