| |
| |
| |
| |
| |
| |
| |
| |
| SQLDetective is a powerful and easy-to-use graphical user interface to Oracle databases. It provides an integrated environment for developing database objects, writing and
debugging stored programs, executing and testing SQL and PL/SQL commands, as well as searching and modifying data and analyzing the dependencies between objects.
|
| |
| What's new in SQLDetective 4.0? |
| Take a screenshot tour |
| |
|
Release History
|
|
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 |
|
| |
|
|
|
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. |
|
