| Full version | Lite version | |||
|---|---|---|---|---|
| New state-of-the-art graphical user interface | ||||
| Office 11 and Windows XP visual schemes support | + | + | ||
| Well-described Wizard System | + | + | ||
| User-friendly database explorer for easy management of all Oracle objects | + | + | ||
| 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 | + | + | ||
| Powerful visual options module | + | + | ||
| Localizable program interface | + | + | ||
| Easy management of all Oracle 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 | + | + | ||
| Rapid database management and navigation | ||||
| Multiple host/database connections | + | + | ||
| Connecting via local port forwarding through the SSH tunnel | + | – | ||
| Registering selected databases to work with | + | + | ||
| 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 | + | + | ||
| Advanced data manipulation tools | ||||
| Powerful BLOB viewer/editor with several types of viewing BLOB data | + | – | ||
| Exporting data to SQL script as INSERT statement | + | – | ||
| Plenty of useful tools such as data grouping, fast search and filtering | + | + | ||
| Multi-level master-detail view to work with several linked tables at the same time | + | – | ||
| Table and card views to see data the way you like | + | – | ||
| Ability to copy and paste selected records | + | – | ||
| 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 | + | + | ||
| Excellent visual and text tools for query building | ||||
| Multiple SQL editors with code completion and syntax highlight | + | + | ||
| Visual query builder allows you to build complicated queries without any knowledge of SQL syntax | + | – | ||
| Large script execution (SQL script editor) | + | + | ||
| Ability to view query plan as diagram | + | – | ||
| SQL Formatter (Available from SQL Editor context menu) | + | – | ||
| Impressive data export and import capabilities | ||||
| Exporting data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc. | + | – | ||
| Exporting data to MS Access | + | – | ||
| Importing data from MS Excel, DBF, TXT and CSV | + | – | ||
| Importing data from MS Access | + | – | ||
| Report designer with clear in use report construction wizard | ||||
| Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree | + | – | ||
| Create Report Wizard allows you to create simple reports in a few clicks | + | – | ||
| Latest Oracle version support | ||||
| Support of all server versions from 8.1.7 to 10g R2 | + | + | ||
| Support of all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE types | + | + | ||
| Powerful and easy management of object permissions, including column-level permissions | + | + | ||
| Powerful visual database designer | ||||
| Saving as image or printing database diagram | + | – | ||
| Ability to create/edit/drop tables and table fields, visually set links between them | + | – | ||
| Reverse engineering | + | – | ||
| And other useful features | ||||
| Keyboard templates | + | + | ||
| External tool manager | + | + | ||
| To-do list | + | + | ||
| Other useful tools to make your work with Oracle server as easy as it can be | ||||
| Extracting metadata into text files or SQL script editor | + | + | ||
| Powerful print metadata module to create customizable metadata reports | + | – | ||
| Report designer for building powerful reports visually | + | – | ||
| SQL Monitor | + | + | ||
| HTML report wizard to create a detailed HTML report about your database quickly | + | – | ||
