EMS SQL Manager 2007 for Oracle

A high performance tool for Oracle Database Server administration and development EMS SQL Manager for Oracle is a 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 types, and others.

EMS SQL Manager for Oracle offers plenty of powerful tools for experienced users such as Visual Query Builder, Visual Database Designer and a BLOB editor to satisfy all their needs.

SQL Manager for Oracle has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.

Here are some key features of "EMS SQL Manager 2007 for Oracle":
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


Requirements:

300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended

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

Possibility to connect to any local or remote Oracle server


Limitations:

30 days trial