SQL Manager Lite for Oracle Changelog

What's new in SQL Manager Lite for Oracle 3.6.1.54485

Jan 21, 2021

The new look with updated icons.
Support of dark visual scheme added.
Added support for Amazon RDS for Oracle.
Added support for the 18C Oracle server version.
Improved support of high-DPI monitors and large-scale fonts.
Support of Unicode added for object names.
Objects can be now added to Favorites from the popup menu.
Databases can be re-ordered in Database explorer now.
Many other bug-fixes.
Other improvements in interface and usability.

New in SQL Manager Lite for Oracle 2.6.0.1 (Nov 30, 2011)

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

New in SQL Manager Lite for Oracle 2.5.0.1 (Nov 30, 2011)

Added the new objects: Queue and Queue Table.
Added the TKProf Wizard to work with TKProf program for handling trace files.
Backup Database Wizard. The possibility to schedule the backup process is added.
Visual Query Builder. If a file is opened, its name is displayed in the window title.
Now SQL Manager does not execute “Alter session set …” queries under the Normal User as they used to result in the “ORA-01031: insufficient privileges” error.
The speed of working with the object tree is increased. The work of the Normal User is optimized.
SQL Script Editor. Added the support of the “/” delimiter for all objects.
“Edit Local Naming Parameters” option is added to the main menu.
Added the possibility to change the password for the Normal User.
The work with two registered databases that had the same ServiceName caused to the “SQL command not properly ended” error if the Schema Restriction option was enabled. Fixed now.
When importing data from the CHAR(1) field with the value of ' ' (a space), this field was imported as empty. Fixed now.
Visual Query Builder. When pressing the Clear button, the query type was not reset to “Select”. Fixed now.
Array Types Editor. The list of objects for quick switching was not filled. Fixed now.
After refreshing and disconnecting from a database and closing SQL Manager, an error occurred. Fixed now.
When moving to the Permissions tab under the Normal User, the ORA-00942 error occurred. Fixed now.
Materialized Views.
When creating a materialized view, an extra “;” was added to the DDL description and an error occurred. Fixed now.
When deleting a materialized view whose editor was running, the DDL of the non-existent view was generated. Fixed now.
When editing a function, the “There is an error in input of field…” message appeared. Fixed now.
When trying to connect through SSH, the “ORA-01031: insufficient privileges” error occurred. Fixed now.
When the “Hide empty schemes” option was enabled, the current user scheme was hidden if it did not contain any object. Fixed now.
Tablespace Editor. If you did not go to the Files tab, data files were not displayed in DDL. Fixed now.
Other small improvements and bugfixes.

New in SQL Manager Lite for Oracle 2.4.0.1 (May 5, 2010)

Database alerts:
New events for monitoring are added.
It is now possible to view the description for each alert and the objects which the alert refers to.
Oracle client check:
The algorithm of Oracle homes searching is changed (e.g. INSTANT_CLIENT and XE_CLIENTS are supported now).
The errors are now displayed with the fixing instructions.
Dependency Tree. The mechanism of the dependency tree building is improved; the building speed is increased.
Added the possibility to enable/disable triggers in the object context menu in the DB Explorer.
Register Database wizard. The new item is added to the “Connect Using” list which indicates that the connection will be performed through TNS_ADMIN.
Environment Options:
The “Quote low case identifiers” option is added.
Added the “Autocreation options” option which automatically creates synonyms when creating a new object.
Field Editor. Added the possibility to imitate an auto increment field by creating a corresponding trigger and a sequence.
Recompilation of invalid objects. Synonyms are added to the list of available objects.
The “Compile With Debug Info” task is added to the drop-down menu of PL/SQL objects.
Scheduler Jobs/Scheduler Windows:
After creating a new metaobject, its editor did not start. Fixed now.
It was not possible to delete several metaobjects at once. Fixed now.
Scheduler Programs. When the Enabled box was checked, the Disable script was generated and vice versa. Fixed now.
After downloading a HTML report and upon refreshing any collection, the "Not enough available timer" message was displayed. Fixed now.
Trigger Editor. It was not possible to set a fields list for which the trigger should fire. Fixed now.
Export as SQL Script from Visual Query Builder. The ROWID column was included in the table DDL. Fixed now.
Export as SQL Script from a view. Table and scheme names were quoted incorrectly. Fixed now.
HTML Report wizard:
Hyperlinks did not work if the object name included the “#” character. Fixed now.
Indices were not indicated as unique in the corresponding column. Fixed now.
Visual Database Designer. If a scheme was not explicitly indicated, a new table was created without columns. Fixed now.
Fixed multiple errors occurred in the asynchronous query execution mode.
When the parsing was disabled, an empty script execution in the SQL Script tool caused an error. Fixed now.
Key mappings for macroses did not work. Fixed now.
Other small improvements and bugfixes.

New in SQL Manager Lite for Oracle 2.3.0.1 (Aug 5, 2009)

New in SQL Manager Lite for Oracle 2.2.0.1 (May 28, 2009)

Create Database Wizard with the ability to create a standby database is added.
DDL. Unicode support is implemented.
Using macro is now possible in SQL Editor and SQL Script.
Added the possibility to connect to databases absent in TNS file.
Query Builder. Added the ANSI join option that allows users to create queries in ANSI-92 SQL standard.
DB Explorer. The Find Object dialog is improved.
DB Explorer. The possibility to reorder database groups by drag-and-drop is implemented.
DB Explorer. The button for switching the search mode is added to the toolbar.
DB Explorer. The program saves the information about the last opened database before shutdown. When it is started next time, this database will be automatically selected in the DB Explorer tree.
DB Explorer. Double-clicking the object group folds or unfolds it.
Most of the options from the Grid | Data Options section of the Environment Options dialog can now be specified individually for each of the registered databases in the Database Registration Info dialog. The values specified in the Grid | Data Options section will be applied as default settings for newly registered databases.
Database Registration Info dialog. Metadata and SQL Editor logs can now be saved in UNICODE or ANSI.
SQL Editor. Creation of queries with identical names was allowed. Fixed now.
Data Grid. The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program.
Data Grid. The mouse cursor color changes when the grid is not active.
Data Grid. Data | Blob View. The XML tab allowing you to view BLOB field values as XML is added.
Extract Database/ Export as SQL Script. Now the script is directly generated in the selected charset which reduces the script generation time.
VDBD. Tables are arranged more compactly in the reverse engineering mode.
Window List. Close All Database Windows command is implemented.
SQL Editor. Fixed several errors concerning SQL code highlighting (alias usage in queries such as “UPDATE : SET :”; when using multiline comments, etc.).
SQL Editor. When saving data to file using any charset different from Unicode, further opening of the save dialogue would set charset to Unicode. Fixed now.
SQL Editor -> Explain query. The scrollbar was absent. Fixed now.
Extract Database/ Export as SQL Script. Extracting external cursor data resulted in the ORA-00900 error. Fixed now.
Extract Database/ Export. The ORA-00900 error occurred when extracting queries with subquery block. Fixed now.
VDBD. Alignment options didn’t work when a diagram was opened from the file. Fixed now.
VDBD. Some printers couldn't print field and table icons. Fixed now.
Dependency Tree. Pressing the Cancel button gave no result. Fixed now.
Other small improvements and bugfixes.

SQL Manager Lite for Oracle Changelog

What's new in SQL Manager Lite for Oracle 3.6.1.54485

New in SQL Manager Lite for Oracle 2.6.0.1 (Nov 30, 2011)

New in SQL Manager Lite for Oracle 2.5.0.1 (Nov 30, 2011)

New in SQL Manager Lite for Oracle 2.4.0.1 (May 5, 2010)

New in SQL Manager Lite for Oracle 2.3.0.1 (Aug 5, 2009)

New in SQL Manager Lite for Oracle 2.2.0.1 (May 28, 2009)

New in SQL Manager Lite for Oracle 1.5.0.1 (Nov 20, 2007)