Editor: Browse the database for 31 different types of objects such as table, view, synonym, function, index, trigger, sequence, constraints, clusters, schema, tablespace, procedure, package, java class, materialized view, database link, type, rollback segment, directory, OperaTor, library, queue, java data, java source, java resource, context, consumer group, index type and job.
Manipulate objects such drop, delete, disable constraints, enable constraints, rollback segment online/offline, commit pending area in consumer groups etc.
Tab through the properties of database objects.
Filter the table and view data.
Add, delete, and update data (in a table) using a simple Grid interface.
Read the PL/SQL code behind views, materialized views, procedures, packages, functions, triggers, and types.
Generate the script for tables, indexes etc.
Reverse engineer objects from an exiting database.
Set the maximum number of records to be returned by a query or when you scroll the data in a table.
A simple and easy to use SQL editor to run queries and generate explain plans.
A simple and easy to use PL/SQL editor to write and compile your PL/SQL code. Easily check the error messages and fix them.
Export data from an existing table or a query in csv, tab delimited or user-defined delimited format. Export the data to Excel. Export the table data as insert statements.
Run individual SQL statements or run a script with multiple statements in the SQL Editor.
Debug the PL/SQL code (future enhancement).
Open a new schema browser or SQL Editor by right-clicking on the button at the bottom of the screen.
Open the window for an already established database connection by clicking on the appropriate button located at the bottom of the application.
Object Browser window to quickly determine the tables and columns available when writing stored procedures or SQL queries.
Refresh the screen to get latest information about database objects.
View DBMS output in the SQL Editor window.
