EMS SQL Manager for Oracle

Features Matrix

 Full versionLite version
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
+
+

Products Navigation

SQL Manager for Oracle

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter