BUILD YOUR DATABASE PROJECTS MORE EASILY
etc depending on the features of the Oracle database versions.
Syntax highlighting and code folding Code Editors,
Oracle Documentation Browser
allow the user to write procedures, functions, packages, object types, triggers and JAVA in a high
quality and error free way.
facilitates easy navigation of database structures by displaying database schema objects and their
relationships in an intuitive hierarchical interface.
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:
WRITE AND TEST YOUR CODE MORE QUICKLY
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
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 the Code Analyzer
- a code review and quality control tool for Oracle PL/SQL development.
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.
ADMINISTER YOUR DATABASE MORE SIMPLY
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.;
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.;
manages tablespaces, datafiles, segments and quotes in the database instance;
manages sessions and displays information on different sessions.
The application also provides the ability to work with Oracle Real Application Clusters (RAC) databases.
empowers DBAs with the powerful and easy to use administrative and monitoring tools and
utilities such as:
MANAGE YOUR DATA MORE SMARTLY
allow users to quickly browse, search, modify, analyze and export&import scalar, object table,
collection, REF and LOB types of data. Utilize advanced Export and Import Data utilities to 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. The powerful
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
allows users to represent the server data model and create a query of any given
complexity, on its basis.
is a complete environment for handling data.
CONFIGURE YOUR ENVIRONMENT MORE CONVENIENTLY
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