SQLGate for Oracle Version History

07/29/2013 : SQLGate for Oracle Update (5.4.1.1)

Contents of Update
-----------------------------------------------------------

# SQL Query Editor

1. The error that parsing cannot be properly done if there is a macro variable(&) in the string has been corrected.

2. [Subquery Copy] has been added to the context menu in SQL Query Editor.

07/15/2013 : SQLGate for Oracle Update (5.4.0.2)

Contents of Update
-----------------------------------------------------------

Contents of the major corrections
----------------------------------------
A new feature that “Display the windows of the connected to current database” has been added.


SQL Query Editor
----------------------------------------
It has been so improved that when there is a record in the result grid, the record which used to be gray with poor visibility can easily be seen now.

06/07/2013 : SQLGate for Oracle Update (5.3.0.2)

Contents of Update
-----------------------------------------------------------
The error that Object Panel cannot be selected when you click with Ctrl key pressed in SQL Query Editor has been corrected.

05/27/2013 : SQLGate for Oracle Update (5.3.0.1)

Contents of Update
-----------------------------------------------------------

General
------------------------------
1. It has been so modified that activation is not allowed if the maintenance period has expired.
2. It has been so modified that automatic updates are not available if the maintenance period has expired.
3. It has been so modified that a counterfeit license cannot be used.
4. The bug in which icons blink in programs has been corrected.
5. The error in which the initial running rate of SQLGate is low in the internetless environment has been corrected.


Export Data
------------------------------

1. The error that occurs when a freeware is activated has been corrected.
2. The error in which high numbers are displayed as strings while exporting data has been corrected.
3. It has been so corrected that an error, if any, is shown properly even in case the field types do not match.
4. It has been so modified that the field of a date format is converted to TO_DATE when exporting data.
5. It has been so modified that the file names are displayed properly after completion of exporting data.


SQL Query Editor
------------------------------
1. The error in which a table with join syntax cannot be modified has been corrected.
2. Parameter AutoComplete has been added.
3. Automatic Highlighting has been added for keyword selection.
4. The feature in which the other user’s object can be chosen during the operation of Table AutoComplete has been added.
5. Move Tab has been added.
6. The error in which you end up in a wrong place when you click while editing a Query statement using mouse has been corrected.
7. The error in which data cannot be corrected when there is a table in the conditional clause has been corrected.
8. Synchronous Scrolling has been added to Grid.
9. Execution of the Command in Grid has been added.
10. The error in which Table AutoComplete does not operate properly in a subquery has been corrected.


PL/SQL Query Editor
------------------------------
1. The error in which a table with join syntax cannot be modified has been corrected.
2. Parameter AutoComplete has been added.
3. Automatic Highlighting has been added for keyword selection.
4. The error in which you end up in a wrong place when you click while editing a Query using mouse has been corrected.
5. The feature in which the other user’s object can be chosen during the operation of Table AutoComplete has been added.
6. Move Tab has been added.
7. The error in which Table AutoComplete does not operate properly in a subquery has been corrected.


Object Explorer
------------------------------
1. The error in which jobs are shown improperly has been corrected.

04/07/2013 : SQLGate for Oracle Update (5.0.1.2)

Contents of Update:
---------------------------------------------
1. Automatic Updates have been so modified as to use Update Installation File.
2. The error in which big numbers are displayed as negative(-) numbers when exporting Excel Data has been corrected.
3. The error in which the last record is not displayed when importing Excel Data has been corrected.
4. The error in which AutoComplete Window shows blank in Field AutoComplete has been corrected.
5. The error in which Table Field AutoComplete does not operate properly in join syntax has been corrected.

03/22/2013 : SQLGate for Oracle Update (5.0.0.6)

Contents of Update:
---------------------------------------------
1. The error ORA-24374 that occurs during execution of PL/SQL in PL/SQL Query
Editor has been corrected.
2. It has been so modified that Excel Data are exported as xls, xlsx file formats.

03/19/2013 : SQLGate for Oracle Update (5.0.0.5)

Contents of Update:
---------------------------------------------
1. The error in which Option Window is not shown properly when Windows Aero
Effect is on has been corrected.
2. The error in which SQL History is not shown properly when Windows Aero Effect
is on has been corrected.

03/19/2013 : SQLGate for Oracle Update (5.0.0.4)

Contents of Update:
---------------------------------------------
1. The error that occurs during importing xls, xlsx files has been corrected.
2. The error in which “Table does not exist” message is displayed during login with
DBA privilege has been corrected.

03/18/2013 : SQLGate for Oracle Update (5.0.0.2)

Contents of Update:
---------------------------------------------
1. You can import xlsx files when importing data.
2. The error that occurrs when connecting to DB has been corrected: “ORA-0942: Table or view does not exist”.
3. The error in which SQLGate terminates abnormally when executing a specific Query has been corrected.
4. The error in which &variable is not handled properly has been corrected.
5. The function of viewing vertical grid is provided.
6. Copying to Clipboard can be restricted in case of freeware, or a trial version that expired.
7. Pop-up advertisements are displayed for ten seconds in case of freeware, or a trial version that expired.
8. Add “Execution Time” row to SQL History.
9. Function has so improved that row and column of the cell are displayed when selecting a cell from Grid.
10. Other errors corrected.

02/25/2013 : SQLGate for Oracle Update (4.5.0.6)

Contents of Update:
---------------------------------------------
1. The error in which data cannot be imported properly in Excel File has been
corrected.
2. Function has so improved that xls, xlsx file formats can all be imported when
importing data in Excel File.

02/21/2013 : SQLGate for Oracle Update (4.5.0.5)

Contents of Update:
---------------------------------------------
1. Function has so improved that sixty five thousand or more of data can be stored when
exporting data to Excel File.
2. The error in which “Schema Description” does not operate properly in SQL Query Editor has
been corrected.
=> The error in which another user’s object cannot be found has been corrected.

02/19/2013 : SQLGate for Oracle Update (4.5.0.4)

Contents of Update:
---------------------------------------------
The error in which Tablespace information is not displayed properly in Tablespace
Manager has been corrected.

02/18/2013 : SQLGate for Oracle Update (4.5.0.3)

Contents of Update:
---------------------------------------------
The error in which “Paste from the code” does not operate properly in SQL Query
Editor has been corrected.

02/13/2013 : SQLGate for Oracle Update (4.5.0.2)

Contents of Update:
---------------------------------------------
1. The error in which Pop-up Menu is not available due to Refresh feature in Session Browser
has been corrected.
2. The error which occurs when adding Temporary Tablespace Data File in Tablespace Manager
has been corrected.
3. The overall speed of Tablespace Manager has improved.
4. Function has so improved that AutoComplete feature is applied to currently logged-in user in
Table Auto Completion.
5. Function has so improved that Cursor is shown in the Record with Return values in SQL
Query Editor.
6. The error in which Raw Field is not displayed has been corrected.
7. Find and Replace feature has improved.
8. The error in which Trigger cannot be chosen when operating Export Script has been corrected.

08/02/2012 : SQLGate for Oracle Update (4.3.1.1)

July 31st, 2012 : Update for SQLGate 2010 For Oracle Dev/Exp/Free 4.3.1.1 Version
Urgent)

The 4.3.1.1 Version is properly updated only by patching twice.

Contents of Update:
---------------------------------------------
1. Bug in which login window was shown two times in Windows 7 has been corrected.
2. SQL Query Editor : Modified to display execution time in milliseconds
3. SQL Query Editor : Bug in which text cursor did not move to end of Editor after execution of SQL Align has been corrected.
4. SQL Query Editor : Various dialogs shown in Korean
5. SQL Query Editor : Bug shown in exponential expression in Folat Field has been patched.
6. Limited Function : Freeware users and users whose trial period has expired cannot access the features of [Export Data] and [Import Data].
7. SQL History : Bug in which SQL History did not normally show in Windows 7 has been corrected.

07/16/2011 : SQLGate 2010 for Oracle Update (4.2.2.5)

Contents of Update:
---------------------------------------------
1. Fixed a bug, which session browser was not refreshed.
2. SQL Query Editor : Added option button, “&” binding variable search or not.

06/13/2011 : SQLGate 2010 for Oracle Update (4.2.1.3)

Contents of Update:
---------------------------------------------
1. Fixed a bug of auto update program.
2. Object Explorer : Fixed a bug that data didn’t change when use Table > Data Filter.
3. Object Explorer : Changed a partition index script when execute Table > Script Output.

05/19/2011 : SQLGate 2010 for Oracle Update (4.2.0.4)

Contents of Update:
---------------------------------------------
1. SQL Query Editor
- Fixed bug that null is not displayed.
- Improved rate when executing query that has many columns.
- Improved rate when executing query that has lots of data.
- Fixed bug when pasting data.

2. Schema Browser
- Fixed changing view name bug.

3. Others
- Added Online Support and Online Purchase menus.
- Added banner.
- Fixed other bugs.

05/19/2011 : SQLGate 2010 for Oracle Update (4.1.0.3)

Contents of Update:
---------------------------------------------
1. SQL Query Editor
Display column name when dragging column of query results grid into the editor.

2. Object Explorer
Fixed bug that popup window is not popped up when selecting mouse right button.

05/19/2011 : SQLGate 2010 for Oracle Update (4.1.0.2)

SQLGate 2010 for Oracle Update (4.1.0.2)

* SQL Query Editor
1. Added a feature, which paste clipboard data to grid.
2. Improved editing rate of SQL Query Editor.
3. Improved “Execution and Modification” execution rate in SQL Query Editor.
4. Fixed bug that letters typing is not supported in a specific location.
5. Fixed bug that the added group is not visible at tree when adding a group in SQL History.
6. Fixed bug that all arithmetic operations is displayed when grid is selected in SQL Query Editor and Open Table.

* Object Explorer
1. Fixed bug that information of synonym is displayed differently at Object Explorer and Object Panel.
2. Fixed AV bug when unauthorized users modify view.

* Data Import
1. Improved rate of data import for table, which has lots of data.

* Others
1. Find in files : Fixed bug that directory is displayed incorrectly.
2. Program Option : Fixed bug that Chinese is displayed incorrectly.
3. PL/SQL Debugger : Fixed bug that letters are not visible at the selected line.
4. Fixed bug, which occurs when installing on 64 bit windows.

11/29/2010 : SQLGate 2010 for Oracle Update (4.0.0.3)

1. SQL Query Editor
- Fixed error of inputted data value when running or modifying current SQL
- Fixed the bug error message wasn’t popped up when violating NULL constraints

2. Import Data, Export Data
- Changed User Interface

3. Update Language Files

11/26/2010 : SQLGate 2010 for Oracle Update (4.0.0.1)

1. Main Form / All
- Assigned shortcut keys for Main menu and Creation window
- Changed User Interface of all Creation windows
- Changed User Interface (Tab control, Toolbar button)
- Improved the issue that afterimage is remained when resizing window
- Changed program terms
- Improved program performance

2. SQL Query Editor
- Fixed the screen blink bug at Field Auto Completion
- Fixed the bug when executing current SQL after selecting characters in editor
- Added options for current SQL separator
- Fixed the bug that program shut down when executing binding variables continuously
- Fixed the bug that initial character of editor was selected when occurring error
- Fixed the bug when assigning the shortcut key

3. Others
- Improved download speed when exporting to excel file
- Fixed the bug that window wasn't restored down after minimizing program
- Improved object importing speed in Object Panel
- Changed Recompile object window to MDI type
- Fixed the bug that filter initialization didn’t work in Object panel
- Displayed data filter as default on Data tab in Description window
- Displayed Procedure/Function/Package on new tab in PL/SQL Query editor window when double clicking one of them

09/10/2010 : SQLGate 2010 for Oracle Update (3.1.2.0)

1. Display Notice for password change when ORA-28002 error (notice for remaining expiration date) is encountered after login.
2. SQLEditor – Fixed bug that copy&paste feature didn’t work on existing Unique key in SQLEditor.
3. SQLEditor – Fixed bug that cannot find object’s information when click ‘Open describe window(F4)’ for partition table.
4. SQLEditor – Fixed bug that cannot find synonym table on the execution of DESC command.
5. SQLEditor – Fixed highlighting for characters bug.
6. Fixed bug that number type is cut.
7. Fixed bug that cannot open a file on the export Dbase file(dbf).

08/30/2010 : SQLGate 2010 for Oracle Update (3.1.1.1)

1. Fixed grid sorting bug.

2. Added view detail window(F4) feature for Synonym, partition table.

08/27/2010 : SQLGate 2010 for Oracle Update (3.1.1.0)

1. ODAC version update
2. DEVExpress version update
3. Fixed a bug related to multilingual.

07/19/2010 : SQLGate 2010 for Oracle Update (3.1.0.6)

1. Fixed the menu error in SQL Result window.
2. Fixed connection window didn’t free memory.

07/15/2010 : SQLGate 2010 for Oracle Update (3.1.0.5)

1. Fixed misunderstanding ‘CR’ character to ‘CR/LF’ character in the SQL Editor.
2. Fixed the SQL Editor is not editable, after opening a file.
3. Fixed removing the wrong character when user pastes code.
4. Added encoding to ANSI, UNICODE on ‘Export Data’ menu.
5. Fixed cutting the Chinese character.

07/01/2010 : SQLGate 2010 for Oracle Update (3.1.0.4)

1. Fixed the drag and drop error in the query builder.
2. Fixed ‘Index Out of Bound’ error, which occurred trying to start SQLGate more than twice.
3. Fixed shutting the SQLGate down when move the tab in the session browser.
4. Fixed the bug, the editor space is not displayed after resizing result window in the SQL editor.
5. Added (FTP/SFTP) feature in the 'TKPROF editor'.
6. Fixed the bug, the application displayed out of the monitor when used one after using multiple monitor.
7. Fixed the bug, shortcut didn’t work after modified by user.
8. Added table filtering feature in the ERD designer.
9. Added ‘SQL Format Option’ feature.

06/24/2010 : SQLGate 2010 for Oracle Update (3.1.0.3)

* Login Window
- Fixed login bug at Unicode Mode.
- Added the feature, change the password for expired account.

06/14/2010 : SQLGate 2010 for Oracle Update (3.1.0.1)

1. New Connection Window
- Added Unicode in the character set.
- OCI Login : Set character set as user’s local character set automatically.

2. Schema Browser.
- Added Scheduler Job Schema (10g or later).
- Added Materialized view, Materialized View Log Schema

3. Added ‘LogMiner’ feature(Developer version).

4. SQL Editor
- Added ‘DBMS_XPlan’ feature (10g or later).
- Added ‘SQL Tuning Adviser’ feature (10g or later).
- Added ‘AWR Report’ feature (10g or later)
- Added feature, docking result window.
- Added feature, converting results to web-script (ASP, JSP and PHP).

5. Added ‘ER Designer’ feature. (Developer version).

6. Miscellaneous
- Fixed bug, Dateformat didn’t display at gird.
- Added MView,MView Log, Scheduler Job in the Report Tool.

05/07/2010 : SQLGate 2010 for Oracle Update (3.0.5.3)

Added support for a simple layout function.
OCI_Invalid_Handle error will not occur in creating more than one Oracle session.
Resolved an issue in importing Text and CSV.
Fixed an issue where SQLGate displays full logs when importing table.
When updating table, SQLGate now displays updated column name.

05/06/2010 : SQLGate 2010 for Oracle Update(3.0.5.2)

1. SQL Editor
- Added support for automatic restore from abnormal termination of SQL Editor
- Fixed a bug in locating error when there is a Korean comment in the query statement.
- Added support for a keyboard shortcut Ctrl+Q to toggle between Editor and Result Grid.
- Added support for a keyboard shortcut (Ctrl+Shift+Q) between Result Grid tabs.
- Fixed a bug with grid in thread destroyed after canceling query.
- Improved auto trace function that didn't work properly.
- Added support for MERGE keyword highlight function.
- Fixed a bug in reporting statistics of the query execution.
- Resolved an issue that displays removed table name in the auto-completion list (10g and above)
- Fixed a bug where SQL history wasn't saved.

2. Schema Browser
- Filtering function in opening table works now.
- Resolved an issue that last Korean character was missing in creating table or adding comment to a column.
- Improved table creator to update the table creation script when inputing default value
- Fixed a bug in opening Update DataType window.

3.Miscellaneous
- Improved toolbar to support vertical alignment.
- Report will be updated when schema is updated.
- Fixed a bug in failing login when multiple version of Oracle client installed.
- Fixed a minor bug in import/export function that didn't display log file in its execution.

05/03/2010 : SQLGate 2010 For Oracle Update(3.0.5.1)

1. Schema Browser
- Fixed a bug where nvarchar and nchar data type was not reported properly.
- Table Information: Constraint column will be removed if constraint is removed.
- Improved an issue that image for PK was broken in displaying table information.
- Resolved an issue that displays several synonyms in partition table.
- Fixed an issue in schema brower (tab style) whose filter options wasn't displayed properly.
- Fixed an issue that couldn't delete view just crated.
- Fixed a bug that detail information didn't show when user selected table name that contains space and press F4 (Describe Schema).

2. SQL Editor
- Improved saving history file
- Added support for keyboard shortcut Shift+Del (Cut function)
- Added support for keyboard shortcut Shift+Backspace (Backspace function)
- Fixed "Select All" button that was broken in group panel view.

3. PL/SQL Editor
- Fixed a bug that los source changes when switching panel view style.

4. New Connection Window
- Fixed a bug that Oracle registry editor doesn't display.
- Fixed a bug where error occurred in connect after selecting all history.
- Fixed an error 'Use Unicode Option must be set to true for Unicode OCI environment' that occurred in login.

5. Miscellaneous
- Fixed "Create Table" windows that didn't disappear on the logout.
- Added announcement windows in the install program.
- Improved export function to export more than 60,000 records to excel.

04/06/2010 : SQLGate 2010 For Oracle Update(3.0.5.0)

1. Automatic Update Program
- Fixed a bug in checking if SQLGate is running.

2. SQL Editor
- Improved handling &(binding) variable.

3. Schema Browser
- Improved importing package feature.
- Added supports for updating and executing package (treeview style)

4. Improved auto-hide feature of object panel.

03/15/2010 : SQLGate 2010 For Oracle Update(3.0.4.8)

- Fixed a bug in selecting sub-query block.
- Modifed execution mode of PL/SQL editor to compile.
- Fixed a bug where the options form doesn't display some characters in windows 7.
- Changed the custor to hand pointer style in folding.
- Fixed SQL creation in security manager.
- Improved speed of hiding object panel.

03/10/2010 : SQLGate 2010 For Oracle Update(3.0.4.7)

- Fixed a bug where the purchase page doesn't display when user clicks "Purchase" button on the first run of SQLGate.
- Fixed an issue of displaying 'Default is not a valid integer value' message when updating a table.
- Fixed procedure/function/package source viewer which missed ',' in the parameter.
- Improved the speed of showing and hiding object panel.
- Fixed a problem in hiding object panel.
- Fixed no response issue of object brower in finding object by clicking left mouse button with control key in SQL editor.

Copyright © 2013 Antwiz Inc. All rights reserved.