Free sql editor for oracle software for windows

EMS SQL Manager 2007 Lite for Oracle 2.2 is an updated tool for Oracle Database Server administration and development. 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.

EMS SQL Manager 2007 Lite 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.

Major Features:

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
   • 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
   
   • Database Information to get all information on database instance and NLS parameters
   • Extracting metadata into text files or SQL Script Editor
   • Client Checker to check the validity of Oracle client and provide common information on client settings
4. 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
   • Duplicating database objects
   • Viewing dependencies between database objects
5. 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
6. Advanced data manipulation tools
   
   • Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
7. Excellent visual and text tools for query building
   • Large script executing (SQL script editor)
   • Favorite Queries (Save and use your frequently used queries easily)
8. 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
9. And other useful features
   • Keyboard templates
   • To-do list
   • External tool manager

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
• Supported Oracle server versions: from 8.1.7 up to 11.1.0