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 | + | + |