EMS SQL Manager for Oracle Freeware 2.2

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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)
9. 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
10. 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
11. 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
12. 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
13. And other useful features
    • Keyboard templates
    • To-do list
    • External tool manager

Enhancements:

1. Added Create Database Wizard with the ability to create a Standby database.
2. DDL. Unicode support is implemented.
3.  Using macro is now possible in SQL Editor and SQL Script.
4. Added the possibility to connect to databases absent in TNS file.
5. Query Builder. Added the ‘ANSI join’ option that allows users to create queries in ANSI-92 SQL standard.
6. DB Explorer.
   • The Find Object dialog is improved.
   • The possibility to reorder database groups by drag-and-drop is implemented.
   • The button for switching the search mode is added to the toolbar.
   • Double-clicking the object group folds or unfolds it.
   • The program saves the information about the last opened database before shutdown. When it is started next time, this database will be automatically selected in the DB Explorer tree.
7. Database Registration Info dialog. Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
8. SQL Editor.
   • Creation of queries with identical names was allowed. Fixed now.
   • Fixed several errors concerning SQL code highlighting (alias usage in queries such as ‘UPDATE : SET :’; when using multiline comments, etc.).
   • When saving data to file using any charset different from Unicode, further opening of the save dialogue would set the charset to Unicode. Fixed now.
9. SQL Editor -> Explain query. The scrollbar was absent. Fixed now.
10. Data Grid.
    • The mouse cursor color changes when the grid is not active.
    • The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program.
11.  Data Grid. Data | Blob View. Added the XML tab allowing you to view BLOB field values as XML.
12. Extract Database/ Export as SQL Script.
    • Now the script is directly generated in the selected charset which reduces the script generation time.
    • Extracting external cursor data resulted in the ORA-00900 error. Fixed now.
13. Extract Database/ Export. The ORA-00900 error occurred when extracting queries with a subquery block. Fixed now.
14. Visual Database Designer.
    • Tables are arranged more compactly in the reverse engineering mode.
    • Alignment options didn’t work if a diagram was opened from the file. Fixed now.
    • Some printers couldn't print field and table icons. Fixed now.
15. Window List. The ‘Close All Database Windows’ command is implemented.
16. Dependency Tree. Pressing the Cancel button gave no result. Fixed now.
17. Other small improvements and bug-fixes.

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 64 MB RAM (128 MB or above is recommended)
• 50MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
• Microsoft Mouse or compatible pointing device
• Oracle Client 8.1.7 or higher
• Local or remote Oracle Database Server 8.1.7 or higher