EMS SQL Manager for Oracle icon

EMS SQL Manager for Oracle 2.2

Downloads :
Total: 101  |  Last 7 days: 1
Product Version :
2.2
Producer :
License type :
Shareware | Price : 275.00 USD
Size :
35.69 MB
Category :
May 28, 2009, 23:21
User Rating : (UNRATED)
OS Supported :
Windows Vista
Windows2003
WinXP
Windows2000
WinNT 4.x
WinME
Win95
Win98

EMS SQL Manager for Oracle Information

Publisher's Description:

High performance GUI SQL tool for Oracle administration and development.

EMS SQL Manager for Oracle is a high performance database tool for Oracle database development and administration. SQL Manager for Oracle works with any Oracle versions from 8.1.7 to the newest one and supports the latest Oracle Database features and data types including compressed, OLAP, read-only and read-write tables; invisible indexes; compound triggers, triggers with FOLLOWS clause and others. It offers plenty of powerful Oracle tools such as PL/SQL Code Debugger, Backup/Restore Database wizards, Visual Database Designer to create Oracle database in few clicks, Visual Query Builder to write complex Oracle SQL queries, Database Statistics to monitor Oracle performance, Grant manager for effective Oracle security management and many more useful features for efficient Oracle administration. 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.

Key Features:

- State-of-the-art graphical user interface
- Connecting via local port forwarding through the SSH tunnel
- Easy management of all Oracle objects (including create/edit/ drop operations)
- Rapid database management and navigation
- Advanced data manipulation tools
- Effective security management
- Excellent visual and text tools for query building
- Impressive data export and import capabilities
- Report designer with clear in use report construction wizard
- Latest Oracle version support
- Powerful visual database designer
- And other useful features
- Other useful tools to make your work with Oracle server as easy as it can be

Details

- 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

Requirements:

Win XP/Vista; 512 MB RAM; 40MB HD space; Oracle Database Client; connection to Oracle server

User reviews

User rating

Your rating:  
Users rating: (0 votes)
 
 
 
 
 
0/5
0/5

Add a Review



(It will not be displayed. Is only for contacting you)
(from the image)
Image Code

!!! Fields marked with * are required !

Latest Database
Software

Universal SQL Editor 1.8.2.1 icon

Universal SQL Editor 1.8.2.1

Intellisense enabled SQL editor for Oracle, DB2, SQL Server,
September 17, 2017, 20:09 | Size: 1.8 MB
SQL Job Manager 3.5.0.4 icon

SQL Job Manager 3.5.0.4

Centralize the process of SQL Management.
January 12, 2017, 07:16 | Size: 12.00 MB
Database Designer for PostgreSQL 1.11.3 icon

Database Designer for PostgreSQL 1.11.3

Intuitive graphical interface allowing you to build a clear and
September 30, 2016, 15:50 | Size: 15.9 MB
CSV Editor Pro 7.0 icon

CSV Editor Pro 7.0

CSV Editor Pro is the professional choice for working with CSV
March 9, 2016, 13:08 | Size: 9.98 MB
HeidiSQL 9.2.0.4949 icon

HeidiSQL 9.2.0.4949

Ease up the management of the MySQL databases.
May 12, 2015, 04:01 | Size: 8.29 MB
SQL Server Fix Toolbox 2.1.4 icon

SQL Server Fix Toolbox 2.1.4

The easiest way of MS SQL database recovery.
November 26, 2013, 11:41 | Size: 7.40 MB
Access Fix Toolbox 2.0.3 icon

Access Fix Toolbox 2.0.3

Repairs corrupted databases in Microsoft Access format
November 26, 2013, 11:34 | Size: 3.06 MB
SQL Server Restore Toolbox 1.0.0 icon

SQL Server Restore Toolbox 1.0.0

Repairs corrupted databases and fixes the damage of MS SQL files.
November 6, 2013, 03:33 | Size: 7.35 MB
MySQL Restore Toolbox 1.0.0 icon

MySQL Restore Toolbox 1.0.0

Allows recovering corrupted databases of MySql format on any
October 28, 2013, 02:49 | Size: 3.8 MB
MDF Viewer Tool 2.0.3 icon

MDF Viewer Tool 2.0.3

A powerful solution for hassle-free viewing of MDF SQL database
October 7, 2013, 04:10 | Size: 7.32 MB

Most Downloaded
Database
Software

Aqua Data Studio icon

Aqua Data Studio

4,049 downloads
SQL Query tool that allows developers to create edit and execute
SQLyog icon

SQLyog

2,459 downloads
Manage and administer MySQL database in an intuitive way.
phpMyAdmin icon

phpMyAdmin

1,562 downloads
phpMyAdmin is a tool written in PHP used to administrate MySQL
Navicat for MySQL icon

Navicat for MySQL

1,211 downloads
Navicat is an ideal solution for MySQL administration and development.
HeidiSQL icon

HeidiSQL

1,145 downloads
Ease up the management of the MySQL databases.
Universal SQL Editor icon

Universal SQL Editor

895 downloads
Intellisense enabled SQL editor for Oracle, DB2, SQL Server,
Toad for MySQL icon

Toad for MySQL

620 downloads
Creates a development environment that improves productivity
SQLCE Viewer icon

SQLCE Viewer

375 downloads
SqlCe Viewer is a database management tool
Database Browser icon

Database Browser

274 downloads
A program for connecting to any database on which the user is
DBF Viewer 2000 icon

DBF Viewer 2000

268 downloads
View, edit, sort, query by example, delete duplicates, create,

Last week
Database
top downloads

phpMyAdmin icon

phpMyAdmin

14 downloads
phpMyAdmin is a tool written in PHP used to administrate MySQL
Advanced ETL Processor icon

Advanced ETL Processor

9 downloads
Automatically extract, transform, validate and load data in any
Visual Importer icon

Visual Importer

8 downloads
Extract, transform and load data into ANY Database from ANY Database
DBF Viewer 2000 icon

DBF Viewer 2000

5 downloads
View, edit, sort, query by example, delete duplicates, create,
Contact | Privacy Policy
Copyright © 2008 - 2017 - All rights reserved.  
RoSoftDownload.com logo