EMS SQL Manager for Oracle Freeware is a database tool that enables efficient Oracle database development and management. It is compatible with Oracle versions ranging from 8.1.7 to the most recent one and incorporates the latest Oracle features.
One of the things I appreciated most about this software is that it supports the latest Oracle Database features and data types. This includes compressed, OLAP, read-only and read-write tables, invisible indexes, compound triggers, triggers with FOLLOWS clause, and more.
Additionally, it boasts a variety of powerful Oracle tools for effective security management and other useful features for efficient administration. But what stands out about this software is its state-of-the-art graphical user interface. The well-described wizard system is so clear and easy to use that even a newbie won't be confused by it.
Some of the key features of EMS SQL Manager for Oracle Freeware include rapid database management and navigation, easy-to-use wizards for Oracle Database administrative tasks, simple management of all Oracle Database objects (including creation, editing, and dropping), advanced data manipulation tools, and excellent tools for query building.
Furthermore, this software supports Unicode data and has a new graphical user interface that truly shines. Overall, I highly recommend EMS SQL Manager for Oracle Freeware to anyone looking for a reliable and efficient tool for Oracle database development and administration.
Version 2.4: Added the ability to connect though TNS_ADMIN, new events for monitoring are added, added the Autocreation option which automatically creates synonyms when creating a new object and much more...
Version 2.2:
- Support of Oracle 11g features
- Unicode support
- partitioning tables and indexes support
- PL/SQL Profiler
- Database Alerts
- wizards working in the background mode
- improved SQL Editor
- Favorite queries
and much more...
Version 1.5:
- PL/SQL Code Debugger was added in SQL Editor
- Added an ability to log the values of bind-variables in SQL Monitor
- Added Tips of the Day
- Statements of type MERGE INTO... USING ... are now parsed correctly
- Updated Polish and updated English localization
- Other great improvements and bugfixes
Version 1.3:
- Oracle Client Checker to check client and home settings on starting the program
- Advanced Statistics Wizard to collect, delete and import/export the statistics on specified objects for optimizer
- Truncate Wizard is added for truncating table and cluster data
- Other great improvements and fixes
Version 1.2:
-Database Statistics form is added.
-Database Information form is added.
-Object Tables support implemented
-The ability to start gathering information for separate table or schema is added.
-Lots of other improvements and bugfixes.