Tool

Feature

Edition

Free

Professional

Enterprise

Each tool Connect to Oracle using SQL*Net or build-in direct TCP/IP connectivity
Pick up connect string from tnsnames.ora file
Sortable history of recent connections
Tag connections using personal description or color scheme
Various skins to personalize visual experience
32 and 64 Bit versions available
Supports Oracle 7.3.4 up to Oracle 12c
Fixed workstation or floating network licenses available
Easily transfer license between machines
SQL-Scratchpad SQL and PL/SQL syntax highlighting
Open SQL from your personal scratchpad tree view
Open SQL from Integrated file explorer or FTP source
SQL query builder supporting both Oracle and ANSI SQL syntax
SQL query execution and updatable result sets
Data presentation as grid, record and text view
Data presentation as tree and pivot view
Data export in MS Excel
Data export in various formats such as MS Access, CSV and much more
KML export of spatial data and presentation in Google Earth
Integrated FastReport engine with automatic and manual layout option
Oracle execution plan presentation as collapsible tree view
Compare files and highlight differences
Expand selected table name to a statement such as SELECT, INSERT, UPDATE or CURSOR FOR LOOP
Oracle PL/SQL profiler interface
Code completion
Delegate SQL execution to SQL*Plus and capture ouput
DBMS_OUTPUT window
Describe selected object
Databrowser Quick launch list shows tables and views including table comment
Click a table or view on the list to open data content view
Tab-switch between multiple open table views
Data presentation as grid, record and text view
Data presentation as tree and pivot view
Pick up foreign key values by master table lookup
SQL filter text box and WHERE condition wizard
Sortable, resizable and hidable columns and build-in filter capabilities
Data export in MS Excel
Data export in various formats such as MS Access, CSV and much more
KML export of spatial data and presentation in Google Earth
Integrated FastReport engine with automatic and manual layout option
Goto master or detail table along referential integrity and pass key values from current row as filter context to the opened master or detail table
Create INSERT/UPDATE/DELETE/MERGE js from currently selected data and visible columns and copy to clipboard or save to file
Optional in-memory grid mode provides additional features such as data grouping, filter value suggestion
Tooltip hints for column headers (data type, constraints and column comment), row headers (instant record view) and data cells (foreign key lookup)
Save work set of open tables and current filter conditions in an XML file for future use
DBMS_OUTPUT window
Tables/Views Overview of tables and views including properties such as comments, tablespaces, timestamps, storage parameters, statistics, several flags
Red highlighting of erroneous views, gray for invalid views. Green highlighting of recently changed tables and views. Confirm button to reset green coloring
CREATE, DROP, DELETE FROM and TRUNCATE tables, views and synonyms for tables and views
Generate and copy to clipboard SQL statements such as INSERT, SELECT, UPDATA, DELETE, MERGE or CURSOR FOR LOOP
Maintenance operations such as tablespace movement, statistics generation, monitoring
Search for table, column, constraint or trigger names
Show DDL for entire table/view or constraint, index, trigger only
Column view with context operations such as rename column, drop column, re-order columns, create sequence, add check constraint
Subordinate views for columns constraints, indexes on column, triggers, privileges, histogram, LOB segment storage, column updatability and bounding rectangle for spatial data columns
Constraints view with context operations such as create primary or unique key, create foreign key, create check constraint, drop constraint, enable/disable
Create index on foreign key columns
Show indexes that support the constraint columns
Show exceptions for disabled or not validated constraint (data that violates)
Create and edit triggers with syntax and PL/SQL error highlighting
Wizards to create instead-of triggers for views, mutating table compound triggers and triggers to set primary key value from sequence
Manage table and index partitions including subpartitions
Manage table and column privileges and show grantees and privileges in cross-table matrix
Manage public and private synonyms for the table or view
Master/detail table diagram shows ER diagram detail view for the current table and allows you to navigate tables along referential integrity
Object dependency view shows objects that depend on or are dependent of the current table or view
Data content view opens a data browser for the current table similar to the Data Content Browser including additional Master/Detail view
View current table access and manage auditing
Detailed table and column statistics view including statistics preferences
Sequences Overview sequences including time stamps, value range, cycle flags
Create, drop or change sequences, increment the counter, show DDL
Manage privileges, synonyms, auditing and view object dependencies
PL/SQL Overview PL/SQL objects such as packages, package bodies, procedures and functions including time stamps and PL/SQL object settings
Show packages and their bodies one below the other
Red grid highlighting of erroneous objects. Green highlighting of recently changed objects, gray for invalid objects. Confirm button to reset green coloring
Create and edit PL/SQL code with syntax and PL/SQL error highlighting
Show DB object cache, pin objects to SGA, compile debug, show DDL
Call interface generator provides anonymous PL/SQL block for instant procedure calls including dbms_output of return value
Manage privileges, synonyms, auditing and view object dependencies
Synonyms Overview synonyms including referenced object
Create, drop or change synonyms, show DDL
Manage privileges
Jobs Manage both Oracle jobs and Oracle scheduler jobs including programs, schedules, windows, window groups and global attributes
Create, run, stop, enable and disable jobs
Show related Oracle initialization parameter
Pipes Create and remove dbms_pipes
Send and receive messages
Purge pipes
DB Links Create and drop database links
Manage synonyms. Show snapshots and transactions
Ping remote database
Materialized Views and MView Logs Materialized Views and MView Logs
Show properties such as SQL query, detail relations, joins, keys, aggregates
Show granted privileges that are required for operating with Materialized Views
Show Materialized View related initialization parameters
Refresh Materialized view
Show DDL for Materialized View and Materialized View Log
Schema Cross-table display of objects in schema, grantees (users and roles), and granted privileges
Yellow cell background when grantee has a private synonym for the object
Reporting capability, create DDL script, export view to MS-Excel, create various administration script
The role hierarchy shows a dependency diagram of all roles that received grants from the schema
Schema dependencies show a dependency diagram of schema owners that have either dependent objects of the schema or depend on objects of the schema
List of invalid objects, PL/SQL errors, not validated constraints, unusable indexes, disabled triggers and context operations to fix these faults
Management of schema triggers with syntax and PL/SQL error highlighting
Show Oracle recycle bin. Several options to purge recycle bin
Schema dependencies show a dependency diagram of schema owners that have either dependent objects of the schema or depend on objects of the schema
Show recently changed objects in grid or calendar view
Global schema operations such as constraints and trigger manager, truncate or drop all objects, mask schema data
Search all tables in schema for string
Java Display Java package hierarchy in collapsible tree view
Manage Java classes, resources, source code and data
Source code editor with syntax and error highlighting
Manage privileges, synonyms and object dependencies
Types Overview collection types, object types, type bodies and incomplete types
Source code editor with syntax and error highlighting
Show type attributes and methods
Manage privileges, synonyms, auditing and object dependencies
Operators View, create and drop operators
Show bindings and arguments
Index Types View, create and drop index types
Show used operators
Dimensions View, create and drop dimensions
View levels and hierarchies
Outlines View, create and drop outlines
Show SQL text
Directories View, create, drop and change directories
Manage auditing and privileges
Show DDL
Libraries View, create and drop libraries
Manage auditing
Show DDL
XML Show XML schemas
View XSD with syntax highlighting
View XML tables and XML views
Tablespaces Overview Tablespaces including properties such as size, free space, status, statistics, default storage and gauge indicators for percentages
Red highlighting of almost full tablespaces
Create, drop and change tablespaces
Maintenance operations such as switch logging or backup option, change status, coalesce, set as default permanent/temporary tablespace, Show DDL. Diagram view of tablespace size and used space
Show datafiles, resize, set online/offline/offline drop
Show free space fragmentation of data file
Show object segments in datafile
Pie diagram view of segment owners and their share of used space and number of segments List of segments in datafile grouped by segment owner and detail list of extents
Manage tablespace quota for users
Manage clusters in tablespace
View sort segment usage and temp segment usage
Users Overview Users including properties such as time stamps, default tablespaces, number of database objects, several status information
Red highlighting of users with elevated privileges such as DBA or SELECT ANY TABLE. Gray highlighting of locked users
Create, drop lock, unlock and change users and passwords
Show DDL for multi-selected users
Show and manage granted roles, object privileges, system privileges and default roles
View and manage tablespace quota for the user
List of objects owned by the user including timestamps and grouped by object type
View tablespace usage of the user
Management of schema triggers with syntax and PL/SQL error highlighting
Show SQL area utilization of the USER including statistics for each SQL statement
View and assign consumer groups
Manage auditing by object, statement and privileges
Sessions Overview sessions including status, blocking, waiting, application info, client, SQL statement incl. syntax highlighting
Optional show multi-instance RAC view
Blocking sessions are highlighted red, sessions waiting for block release or pipe get are highlighted yellow, killed and inactive sessions gray, active transactions green
Kill or disconnect session. Switch SQL trace on or off
View locks and block waiting graph
View session transactions, long operations, access and latches
View session statistics and wait events
View open cursors and syntax highlighted SQL statement
Database Database overview sheet showing versions of database components, installed options, licenses and other properties such as character set, log mode, global db name and resource costs
Database instance information including host name, startup time, archiver status
Undo segment list including status, tablespace, size, statistics, extent info and additional undo related information such as undo tablespace size, undo retention time, undo statistics time usage
NLS parameters overview for database, instance and session including comment and nls_lang related registry settings of the client
Showing session and system related initialization parameters and change in either memory, spfile or both scope
List of control files and control file record section
Overview database roles and detail views for granted roles, directly and by subordinate role granted object privileges, system privileges and grantees of the role. Manage role privileges using comfortable dialogs
Show and manage profiles and resource limits
Management of database triggers with syntax and PL/SQL error highlighting
List of data files for all tablespaces and similar management functions to the tablespace view
Showing ASM disc groups and attributes
Zoomable diagram of object owner dependencies of the entire database
Show system statistics
List of database features, usage and statistics
SGA Instance SGA view as pie diagram and data grid
Show SGA component memory usage
SGA relates database parameters
Library cache view and DB object cache detail view by namespace
Row cache view
Buffer cache view by buffer pool and buffer cache related statistics
SQL area with several instant filters for top-resource-consuming sessions and SQL display including syntax highlighting
System event statistics, wait statistics and system statistics
Result cache statistics, parameters and object list
SQL plan baselines
Dictionary List of Oracle data dictionary views grouped by view prefix such as ALL_, DBA_
Search for dictionary views
View column list including comments
Dictionary view content browser
Data Pump List of data pump jobs and data pump sessions
Display of server host name and data pump directory
Add job for export, import or SQL file
Stop job
View job status
AWR Requires a valid license for the Oracle Enterprise Manager Diagnostic Pack
List of AWR snapshot per instance
Create new snapshot
Create AWR report
View AWR baseline
View SQL history for snapshot interval including execution time, SQL statement
Reverse Database Engineer Create DDL script for entire schema from data dictionary information
Select database objects
Optionally exclude tablespace and storage parameters, reset sequence counter
HTML Documentation Create HTMl documentation for entire schema from data dictionary information
Choose between English and German language option
Hyperlinks for cross-references between objects
SQL Editor Stand-alone version of SQL editor
SQL and PL/SQL syntax highlighting
SQL query builder supporting both Oracle and ANSI SQL syntax
SQL query execution and updatable result sets
Data presentation as grid, record, text, tree and pivot view
Data export in various formats such as MS Excel, MS Access, CSV and much more
KML export of spatial data and presentation in Google Earth
Integrated FastReport engine with automatic and manual layout option
Oracle execution plan presentation as collapsible tree view
Compare files and highlight differences
Expand selected table name to a statement such as SELECT, INSERT, UPDATE or CURSOR FOR LOOP
Oracle PL/SQL profiler interface
Code completion
Delegate SQL execution to SQL*Plus and capture output
DBMS_OUTPUT window
DB Compare Compare two database schemas
Mark database objects as changed, added or removed
Highlight object changes in DDL script
Create basic DDL script to consolidate schemas
ER Diagrammer Create ER diagram for database schema from data dictionary information
Automatic layout places independent tables on the left and dependent tables right next to the master table
Create multiple subset diagram views for the model
Copy diagram subsets to clipboard for use in your own documents
Context menu items for table and foreign key definition
PL/SQL Debugger Debug PL/SQL code
Trace into, step over, trace out and run
Add, toggle and remove breakpoints
View call stack
Add watches
Evaluate and modify variables
dbms_output window