Latest Oracle Database version support
- Support of the latest server versions from 8.1.7 to 11g
- 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
- 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
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 SQL 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
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
- Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
- Multiple SQL editors with code completion, syntax highlight, code folding and PL/SQL code debugger
- Large script executing (SQL script editor)
- Ability to view query plan as diagram
- SQL Formatter (Available from SQL 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
- Office 11 and Windows XP visual schemes support
- 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
- Powerful Visual Options module
- Localizable program interface
And other useful features
- Keyboard templates
- To-do list
- External tool manager
