|
|
|
|
|
| |
SQLDetective 4.3
|
ClearSQL 5.0
|
ClearDB 2.0
|
| BUILD YOUR PROJECTS MORE EASILY |
| 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 the
objects. Visual object editors allow users to quickly create
and modify database objects such as: table,
view,
trigger,
index,
job,
cluster,
synonym,
operator,
etc depending on the features of the Oracle database versions.
Syntax highlighting Code Editors, Code
Helper, Code
Insight and Integrated Oracle
Documentation Browser allow the user to write procedures,
functions, packages, object types, triggers and JAVA in a high
quality and error free way. Object
Navigator facilitates easy navigation of database
structures by displaying database schema objects and their
relationships in an intuitive hierarchical interface. |
| |
| WRITE AND TEST YOUR CODE MORE QUICKLY |
| is a range of handy
utilities to tune SQL scripts, test PL/SQL statements, write
and execute stored programs, debug stored objects
step-by-step. SQL
Editor executes SQL and PL/SQL statements supporting bind
and substitute variables. The advanced Stored
Program Editor offers an easy-to-use interface for writing
and executing stored programs. The fully integrated PL/SQL
Debugger offers all features that a user could wish for:
step over, step into, step out, run until exception, break
execution, set conditional breakpoints, view and modify scalar
and complex variables and more, to debug stored procedures,
functions, packages, type bodies and triggers on a database
server. Format and improve the quality of PL/SQL code using - a code review and quality
control tool for Oracle PL/SQL development. |
| |
| ADMINISTER YOUR DATABASE MORE SIMPLY |
| empowers DBAs with the powerful and easy to use administrative and monitoring tools and utilities such as:
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, etc.;
Database Monitor monitors real-time database performance and displays: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time,
Sort Ratio, SGA, Hit Rates, Recursive Calls, and many others in charts grouped by categories; Top Session Locator locates the most resource consuming sessions
in the database using different activity and Event Waits parameters such as: CPU, Logical I/O, Physical I/O, Parsers, Concurrency, User I/O, System I/O, etc.; Storage Manager manages
tablespaces, datafiles, segments and quotes in the database instance; Session Navigator manages sessions and displays information on different sessions. |
| |
| MANAGE YOUR DATA MORE SMARTLY |
| is a complete
environment for handling data. Smart
Dataset allows users to quickly browse, search, modify,
analyze and export scalar, object table, collection, REF and
LOB types of data. The powerful Dataset
Builder allows users to create complex datasets without
having to write a query. The Data
Dependency Analyzer provides a graphic environment to
represent and modify the referring data based on integrity
constraints. The graphical Query
Builder allows users to represent the server data model
and create a query of any given complexity, on its basis.
|
| |
| CONFIGURE YOUR ENVIRONMENT MORE CONVENIENTLY |
| is a quality product
that has been developed using plug-ins. This technology allows
users to customize the product to the business processes being
run by the user when developing, implementing and supporting
Oracle-based applications. The program features a fast,
easy-to-use environment that allows users to customize the
workspace and visual tools on request. The Oracle Client Interface (OCI)
allows users to utilize all database benefits and dispenses with the
installation of additional drivers (e.g. ODBC or JDBC) in user's workstation.
|
|
