EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

Product News

EMS SQL Manager for Oracle version 2.6 released

We are pleased to announce the new minor version of SQL Manager for Oracle - a high performance tool for Oracle database server administration and development.

You can download the newest version of SQL Manager for Oracle from the download page.

What's new in SQL Manager for Oracle 2.6?

  1. SQL Editor and SQL Script.
    • Added the possibility to set timeout for query execution.
    • It was not possible to cancel a query using the “Asynchronous Query Execution” option. SQL Editor hanged up when performing large queries. Fixed now.
  2. Added the possibility to detect resource-intensive queries whose execution could take a long time (more than 10 seconds).
  3. Now if the Oracle Home list is empty (the client is not set), an alert message occurs.
  4. Now when setting a string type for the newly created table field, the size is set to 10 by default.
  5. Added the possibility to select the “multi-insert” option when exporting data as SQL-script (if this option is supported by the server).
  6. The changing of the "Object Type Body" source code caused the lost of the custom formatting. Fixed now.
  7. It was not possible to quote identifiers when using the “Convert created object names to upper case” option. Fixed now.
  8. If a field name started with a number, the error message occurred upon the data export. Fixed now.
  9. If none of the databases was registered upon using the "Edit local naming parameters" option, AV error occurred. Fixed now.
  10. When creating the "Flashback” restore point, the "Invalid identifier or cannot open address file" error occurred. Fixed now.
  11. When duplicating the table with the replacement of the layout scheme, the tablespace changed incorrectly. Fixed now.
  12. Query Builder. When executing queries such as "Insert As Select, AV error occurred. Fixed now.
  13. Create procedures. After pressing the “Compile" button in the "Convert created object names to upper case"option, AV error occurred. Fixed now.
  14. It is now possible to execute queries, which contain string values with the “ ’ ” (apostrophe) symbols.
  15. It was not possible to insert rows with 1000 and more characters into the varchar (4000) field. Fixed now.
  16. When selecting the "Autoincrement" option to edit the previously created field, the autoincrement metadata was not created. Fixed now.
  17. When creating a key, the value inserted into the "Tablespace" filed was ignored. Fixed now.
  18. There were redundant records in the grid, when executing queries such as "select cast (fieldname as varchar (100)) from tablename". Fixed now.
  19. Objects located in the current tablespace were not displayed. Fixed now.
  20. Some other improvements and bugfixes.

We hope you’ll enjoy working with our products!