EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

All News & Events

SQL Manager for Oracle released!

EMS Company is pleased to announce EMS SQL Manager for Oracle - a brand new high performance tool for Oracle Database Server administration and development. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to 10g and supports all Oracle objects and all Oracle data types including the new BINARY_FLOAT and BINARY_DOUBLE, and so on. It offers plenty of powerful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. Rich functionality and friendly GUI of the new SQL Manager provides Oracle administrators and developers with significant advantages against the native Oracle database administration tools.

SQL Manager for Oracle is also available in freeware (lite) version that has some restrictions in the functionality. Nevertheless, it allows to perform the full scope of essential operations.

Learn full information at the product webpage: http://sqlmanager.net/products/oracle/manager

You can download SQL Manager for Oracle at: http://sqlmanager.net/products/oracle/manager/download

The trial period lasts 30 days.

EMS SQL Manager for Oracle Features:

Rapid database management and navigation

  • Multiple host/database connections
  • Registering selected databases to work with
  • Schema restriction to see only required schemas
  • Projects to work with the selected database objects only
  • Connecting via local port forwarding through the SSH tunnel
  • 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

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

Advanced data manipulation tools

  • Powerful BLOB viewer/editor with several types of viewing BLOB data
  • 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
  • Exporting data to SQL script as INSERT statement

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

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

  • Visual query builder allows you to build complicated queries without any knowledge of SQL syntax
  • Multiple SQL editors with code completion and syntax highlight
  • Large script execution (SQL script editor)
  • Ability to view query plan as diagram
  • SQL Formatter (Available from SQL Editor context menu)

Report designer with clear in use report construction wizard

  • Create Report Wizard allows you 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

Powerful visual database designer

  • Ability to create, edit and drop tables and table fields, set links between tables visually
  • Reverse engineering
  • Saving as image or printing database diagram

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

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

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

And other useful features

  • Keyboard templates
  • To-do list
  • External tool manager

Learn full information at the product webpage: http://sqlmanager.net/products/oracle/manager

You can download SQL Manager for Oracle at: http://sqlmanager.net/products/oracle/manager/download

The trial period lasts 30 days.

We would like to bring it to your attention that EMS SQL Manager for Oracle is distributed within EMS Maintenance Program – the basic product price includes 1 Year Maintenance for free! There are also variants with 2 and 3 Year Maintenance available for sale that allow to decrease the cost of annual maintenance. You can learn more about EMS Maintenance Program at: http://www.sqlmanager.net/support/faq/maintenance

We hope you’ll enjoy working with our products!