Softpedia >Windows >Internet >Servers >Database Utils >SQL Manager for Oracle >  Changelog

SQL Manager for Oracle Changelog

What's new in SQL Manager for Oracle 3.4.1 Build 49919

Feb 27, 2018
  • Data frame. Now you can add conditions to Quick Filter with Shift button.
  • "Reduced precision" option has been added for Materialized Views.
  • Search of objects has been improved in Visual Database Designer.
  • Default parameters are processed correctly on executing procedures now.
  • "ORA-30757" error occurred on displaying XMLData values. Fixed now.
  • The error occurred when launching the program on OS with Breton locale. Fixed now.
  • Column autowidth was applied incorrectly in some cases. Fixed now.
  • Errors of editing partitions in Index editor have been fixed.
  • Delete rule was not applied for new objects in Foreign key editor. Fixed now.
  • It was not possible to set the "Follow trigger" option to none in Trigger editor. Fixed now.
  • Some errors in Scheduler Window editor have been fixed.
  • Some errors in Scheduler editor have been fixed.
  • Replace dialog. "Yes to all" button did not work properly if "Prompt on replace" option was enabled. Fixed now.
  • Many other improvements and bugfixes.

New in SQL Manager for Oracle 3.4 (Feb 27, 2018)

  • Considerable improvement of performance in SQL Script, Extract Database, Compare Database and Dependency Tree tools.
  • BLOB Editor. Support for viewing PDF data has been implemented.
  • Ctrl+C can be used for copying text from error messages now.
  • Out of memory error on extracting large amounts of data has been fixed.
  • With UTF-8 connection national symbols were lost on executing DDL statement. Fixed now.
  • Code Folding feature has been improved.
  • Multiline /* */ comments were not highlighted correctly. Fixed now.
  • The errors of processing reports have been fixed.
  • Many other improvements and bug-fixes.

New in SQL Manager for Oracle 3.3 (Feb 27, 2018)

  • The approach of working with data buffers has been changed. The memory is allocated now only for real data stored in the table, and not just relying on its definition. It has lead to a considerable economy of memory.
  • The mechanism of user schema filtration has been improved. Now all the database editors, services and tools work only with the set of schemas indicated in the schema filter in the DB registration.
  • Compare Databases. The mechanism of ordering of objects as per their dependencies has become better and faster. Now there is a possibility to compare only the schema objects, ignore objects of the schema PUBLIC, ignore objects’ parameters storage.
  • Extract Databse. The mechanism of ordering of objects as per their dependencies has been refined and significantly improved.
  • Duplicate Table. Now there is a possibility to choose sub-objects.
  • Databases that are connected through SSH, are now marked with the special sign «lock-up».
  • Now one can simultaneously execute several queries in SQL Editor, separated by “;” with browsing their data sets.
  • The current schema in the objects tree is now marked with bold-faced type.
  • Query Builder parser work with the big number of ANSI joins has been fixed.
  • Numerous errors related to group editing (deleting, relocation ..) in Visual Database Designer (VDBD) are fixed now.
  • Export data of large data sets used to finish with the error “Out of memory”. Fixed now.
  • Running multiple instances of DB Comparer was finished with the error Out of Memory. Fixed now.
  • SQL Editor. During the process of asynchronous execution of the long query with the specified timeout the query was interrupted and the data set was closed, even in the case when the query met the timeout limits. Fixed now.
  • Many interface errors in case of editing the Storage Data for the table are fixed.
  • Incorrect work with the ISO8859-5 DB encoding. Fixed now.
  • Other improvements and bug fixes.

New in SQL Manager for Oracle 3.2.0.43014 (Dec 30, 2013)

  • Use of sequences in fields editor. Support of autoincrement fields.
  • DEFAULT ON NULL option of column editors.
  • Size of varсhar type fields is up to 32767 bytes.
  • PL/SQL subprograms in WITH … SELECT queries.
  • Partitioning mechanism is improved:
  • Online move of partitions (without demounting database);
  • Delete and remove several partitions at once;
  • Split and merge partitions.
  • Granting and revoking program module roles.
  • Support of limits when uploading table and view data.
  • Support of KEEP … SESSION option in sequences.
  • Extract Database. Option "Delete existing records" is added.
  • Role editor. Support of IDENTIFIED USING option.
  • HTML Report. Operating procedure is significantly improved; HTML reports are created much faster now.
  • When connecting through SSH, if SID and alias in tnsnames.ora were different, the connection error ORA-12514 occurred. Fixed now.
  • When saving the diagram of Visual Database Designer as image, it was cut. Fixed now.
  • Despite the restrictions set in "Schema Restriction" the whole range of schemas was requested from the server. Fixed now.
  • When opening large tables the query interruption occurred with the4 second time-out, despite the time-out settings. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Manager for Oracle 3.1.0.1 (Sep 24, 2013)

  • Debugger PL/SQL code. The mechanism is fundamentally changed; a lot of bugs is fixed. Visual Options are “remembered” now.
  • Recompile invalid objects. The mechanism is fundamentally changed and improved. It is possible to determine invalid dependencies and to recompile both single problem objects and all dependencies as a whole.
  • A new "Calculate dependencies" option appeared in Extract Database. It analyses dependencies and arranges them in accordance with the use.
  • At any start/restart of the current connection when "Use separate connections for each data view within a database" option at Data options was on, AV error occurred. (e.g., SQL Editor, SQL Script, Register DB Options). Fixed now.
  • When "Schema restriction" option for PUBLIC and Current at Operator Editor was on, AV error occurred. Fixed now.
  • The DATE values were wrongly double-quoted importing from CSV. Fixed Now.
  • If close several editors with the right-click menu of the windows bar (Close All) and open editor of other object, the close of unnecessary editors stopped. Fixed now.
  • Data Manipulation | Export Data. “Failed: Out of Memory” error occurred when exporting table data with a great number of rows. Fixed now.
  • DB Explorer. If the object was not deleted in DB Explorer, it was possible to open it in DB Explorer. Fixed now.
  • If a table and a cluster with the same name were created, the cluster columns were added to the table columns when opening the table; if open the cluster, the table columns were added to the cluster columns. Fixed now.
  • When "Sort by aliases" was on, the table fields were sorted in object tree. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Manager for Oracle 3.0.0.0 (Sep 24, 2013)

  • Added the Database Comparer tool which allows getting a script to synchronize the database structure.
  • The Search in Metadata tool is implemented for performing the quick search within the scope of database metadata. The tool allows you to set various search conditions and view the results.
  • Visual Database Designer:
  • Added the 'Undo' and 'Redo' operations.
  • Added tools for formatting diagram objects: setting fonts, colors, etc.
  • HTML Report. Now it is possible to define the report visual style.
  • Added the Database Registration Manager which allows adding and deleting database registrations quickly.
  • Added the Instance Manager service which allows checking the service status of Oracle server and staring/stopping the service.
  • Added the possibility to define shortcuts not only for SQL Editor commands, but for some other commands too (Environment Options | Global Shortcuts).
  • SQL Formatter now allows formatting DDL statements.
  • The switching between windows is now performed with the Ctrl + Tab shortcut.
  • Added the possibility to duplicate objects in other databases by drag-and-dropping them in DB Explorer.
  • Now it is possible to set the Connection string manually, while creating a database connection.
  • Save and Restore layout. Now it is possible to save the column width while executing queries to SQL Editor and SQL Query Builder.
  • Added the possibility to set the font size only in DataGrid.
  • Many other small improvements and bugfixes.

New in SQL Manager 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 for Oracle 2.5.0.1 (Nov 18, 2010)

  • 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 for Oracle 2.3.0.1 (Aug 5, 2009)

  • Added a number of new Oracle 10g objects: Scheduler Job Classes, Scheduler Jobs, Scheduler Window Groups, Scheduler Windows, Scheduler schedules, Scheduler programs, Scheduler chains
  • Improved SQL Script performance. SQL statements parsing enhanced
  • Now table and view objects are not refreshed if the Refresh on connect option is enabled
  • Object editors’ performance enhanced, the dependencies are loading faster when switching to the Dependencies Tab
  • DB Explorer. The utility automatically hides SQL Assistant to increase performance
  • Materialized View. It is now possible to create and edit partitions
  • DB Explorer. It is now possible to drag-n-drop objects between different database groups
  • Query Builder. Select mode. The field created in the Selection section disappeared after saving and re-loading a diagram. Fixed now
  • Query Builder. Update mode. The Delete Current Row function deleted a row from the diagram only, not from the query text. Fixed now
  • Query Builder. After creating a query with a subquery at the Edit tab, the subsequent switching from the Edit tab to the Builder tab resulted in “ORA-00942: table or view does not exist” error. Fixed now
  • SQL Editor. With the Asynchronous query execution option enabled, query syntax errors were not displayed. Fixed now
  • SQL Editor. When executing a query with the Asynchronous query execution option disabled and then executing the same query with this option enabled, the Access Violation error occurred. Fixed now
  • DB Explorer. The new tabs created in the DB Explorer were minimized after the utility restart. Fixed now
  • Even if the Login prompt before connection option was enabled, the program stored the password in system register. Fixed now
  • Keyboard templates. The inactive templates became active after the utility restart. Fixed now

New in SQL Manager 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.

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

  • PL/SQL Code Debugger implemented
  • Tips of the Day added
  • updated localizations