Features

  Full version Lite version
Latest Oracle Database version support
Support of the server versions from 8.1.7 to the newest one
Support of compressed tables, OLAP tables, read-only/read-write tables, virtual columns
Support of invisible indexes
Support of compound triggers, triggers with FOLLOWS clause
Powerful and easy management of object permissions, including column-level permissions
Support of Unicode data
Rapid database management and navigation
Multiple database connections
up to 5
Connecting via local port forwarding through the SSH tunnel
Schema restriction to see only required schemas
Projects to work with the selected database objects only
Multiple user-defined tabs for any tree node to access it in one-click
Working with multiple selected objects at a time
Grouping/Ungrouping registered databases
Database Registration Manager to quickly add and delete database registrations
Powerful tools to make your work with Oracle Database as easy as it can be
PL/SQL Code Debugger for step-by-step code debugging of anonymous blocks, procedures, functions, packages, triggers, object types
Database Statistics to provide all essential statistics on the database: system statistics, statistics on sessions; statistics on storage, wait events, latches
Database Information to get all information on database instance and NLS parameters
Extracting metadata into text files or Execute Script editor
Powerful print metadata module to create customizable metadata reports
HTML Report Wizard to create a detailed HTML report about your database quickly
Client Checker to check the validity of Oracle client and provide common information on client settings
Database Comparer tool to get a script for synchronizing the database structure
Search in Metadata tool to perform a quick search within the scope of database metadata
Instance Manager service to check the service status of Oracle server and to start/stop the service
Easy-to-use wizards performing Oracle Database administrative tasks
Backing up database
Restoring database
Collecting and managing optimizer statistics
Recompiling invalid objects
Enabling/Disabling constraints
Truncating table or cluster data
Simple management of all Oracle Database objects (including create/edit/drop operations)
Managing tables and all their subobjects: fields, primary, unique and foreign keys, indices, triggers, and check constraints
Managing views and all their subobjects: fields, triggers, primary, unique and foreign keys
Managing procedures, functions, sequences, packages and package bodies
Managing users, roles, profiles, consumer groups and resource plans
Managing database and schema triggers, clusters, synonyms, database links, materialized views and materialized view logs
Managing object and array types, object type bodies, libraries
Managing java sources, resources and classes
Managing index types, operators, dimensions
Managing contexts, directories, table spaces, rollback segments, redo log groups
Managing jobs
Duplicating database objects
Viewing dependencies between database objects
Effective security management
Grant manager displaying all database object grants in the form of a grid
Ability to set permissions for table columns
Easy management of database users, roles and profiles
Viewing and changing object permissions in object editors
Advanced data manipulation tools
Powerful BLOB viewer/editor with several types of viewing BLOB data
Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
Master-detail view to work with two linked tables at the same time
Table and card views to see data the way you like
Ability to copy and paste selected records
Advanced printing system
Excellent visual and text tools for query building
Query Designer allowing you to build complicated queries without any knowledge of SQL syntax
Multiple Query Data editors with code completion, syntax highlight, code folding and PL/SQL code debugger
Large script executing (Execute Script editor)
Ability to view query plan as diagram
SQL Formatter (Available from Query Data editor context menu)
Favorite Queries (Save and use your frequently used queries easily)
Impressive data export and import capabilities
Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc.
Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
Exporting data to SQL script as INSERT statement with selecting destination DBMS
Visual Database Designer to handle database structure in a few clicks
Creating diagram of existing database using Reverse engineering tool
Dividing diagram into different subject areas located on separate pages
Navigating through diagram using preview navigation to
Creating/editing/dropping tables, views and table fields, visually setting links between them
Ability to add comments to diagram
Saving as image or printing database diagram
Two diagram notations (IDEF1x and IE)
A lot of visual customization options
Report Designer with clear in use report construction wizard
Create Report Wizard to create simple reports in a few clicks
Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree
New state-of-the-art graphical user interface
The possibility to choose different visual schemes
Well-described Wizard System
Improved database explorer for easy management of all Oracle objects
MDI and floating-window styles implementation
Windows Toolbar to switch between windows easily, like in Windows Task Bar
Navigation bars with hot actions in most of the windows
Ability to save all program settings
Customizable toolbars for all program windows
Fully customizable program interface
Support of dark theme
Localizable program interface
And other useful features
Keyboard templates
To-do list