Version History

New Features & Improvements

• Added option to adjust main menu font size
  Users can now freely adjust the font size of the main menu for improved readability.

• Added auto-completion for bind variables
  Auto-suggestions are now provided for bind variables in the format :variableName during SQL writing.

• Improved auto-completion performance for bind variables
  The response speed of the auto-completion feature has been enhanced for a smoother user experience.

• Improved theme switching speed
  Theme transitions (e.g., Dark/Light) now occur faster with reduced latency.

New & Improved Features

• Oracle Cloud Wallet Login Support
  You can now log in using Oracle Cloud Wallets directly within SQLGate.

• Improved OCI Login Initialization
  SQLGate now prioritizes loading the TNS_ADMIN environment variable during OCI login, ensuring more stable and predictable connection handling.

• Mixed Connection Support
  Users can now use both Direct Connection and OCI Connection modes simultaneously within the same environment.

• Enhanced PL/SQL Editor Performance
  The PL/SQL editor now loads more than 3x faster, improving productivity and user experience when working with large PL/SQL scripts.

Bug Fixes

• Login Failure on Latest Oracle Versions
  Resolved an issue where users were unable to log in after updating to the latest version of Oracle.

• Object Panel – Missing Packages from Other Users
  Fixed a bug where packages or package bodies owned by other users did not appear in the Object Panel.

• Object Panel – Missing Job Schedulers from Other Users
  Fixed an issue where job scheduler entries from other users were not shown in the Object Panel.

• DBA Recognition Issue
  Fixed a bug where users with the SELECT ANY DICTIONARY privilege were not recognized as DBAs.

• SWS File Load Issue with Multiple Panels
  Fixed an issue where SWS (SQLGate Worksheet) files were not properly restored when using three-panel layouts.

• Session Statistics Display Bug
  Fixed a bug where "Session Statistics" under "Execution & Session Statistics" did not function correctly in the SQL Editor.

1. Fixed a bug where the partition table is not displayed in the object list

2. Improved the script for the partition table to appear

1. 1. Remove the feature to retrieve all records when dragging the column header in grid mode.

1. Bug fix for objects selected in Auto-Complete in Editor Options not being applied immediately

2. AV error fix in Object Highlight

3. Message processing when deleting one or more records in F6 mode

4. Bug fix for column sorting not working in grid mode

1. Improved the function to assign auto commit to each session

2. Improved the function to search for objects in the object panel without case
sensitivity

3. Fixed a bug where negative numbers were not displayed correctly in the grid

4. Fixed a bug where object scripts did not work correctly in the tabbed object panel

5. Fixed a bug where objects selected in the object auto-completion in the editor options were not immediately applied

1. Bug fix that prevents data from being modified intermittently in the grid

2. AV error fix when moving columns in table creation

3. Bug fix that prevents skins from being applied correctly when forced to close after changing the theme

4. Improved table script export speed

5. Removed inconvenience of having to add an alias name when the login password is incorrect

1. Fixed a bug where the correct value was not copied when copying to the clipboard after sorting columns in the grid.

1. Added option to add grid column header to SQL editor

2. Fixed issue where compilation error occurs during object recompilation and stops immediately

1. AV error patch when Ctrl+Click is pressed in SQL editor

2. Bug patch where object highlight in SQL editor changes to random color

1. Add CTE auto-completion feature

2. Do not display SQLGate-specific comments when dictionary query error occurs

1. Bug fix for the last logged-in tab not being activated in the free version

2. Bug fix for the compile result not being displayed in the object recompile

3. Add "New View" to the right mouse button in the view menu in the object panel

4. Added a resizing function for the data import window

5. Function improvement for loading login information of the 6.X version

6. Added a "Always on top" checkbox to the binding variable window

7. Added a load function after saving the last position to the binding variable window

8. Other bug fixes

1. Fix bug that prevents Generator64.dll from loading

SQLGate for Oracle Version 10 Released

1. Changed from 32-bit to 64-bit version

2. Oracle client supports only 64-bit version

3. Consolidated connected sessions into 1

4. Improved initial loading speed and database connection speed

5. Provided work area save and open function (sws extension)

6. Added session disconnection function during query execution

7. Added function to change to another session in the editor

8. Provided full grid column selection function in the SQL editor

9. Partial record retrieval / all record retrieval selection is possible in the SQL editor

10. More than 3 million records can be retrieved without memory error in the SQL editor

11. Improved speed of grid display after query execution in the SQL editor

12. Improved grid speed when querying CLOB, BLOB, RAW type data in the SQL editor

13. Improved speed when using binding variables in the SQL editor

14. Added function to move to the position of the ')' character when clicking the '(' character in the SQL editor

15. Binding variable window in the SQL editor Added a function to run without closing

16. Improved Replace, Undo, Redo speed in SQL editor

17. Added an icon to the tab when executing a query in SQL editor

18. Changed the color of the progress bar to the same color as the session in SQL editor

19. Added a function to specify the color of the cell when directly modifying the cell in the grid

20. If you cannot connect to the update server offline, run it without connecting to the update server

21. Changed the function to change the tab name immediately without pressing Enter

22. Added a schema filter function to the object panel

23. If the session is forcibly disconnected, the work area is not closed

24. Changed the XLS format to XLSX format in report export

25. Packaged so that it can be installed on MAC OS
 

Patches

1. Fixed a bug that caused a "database is locked" error when modifying a record

2. Fixed a bug that caused screen afterimages to appear at a specific resolution in a DVI environment

3. Fixed a bug that caused the location of a specific control in a DVI environment to keep changing

4. Fixed a bug that caused data to change when a specific folder does not exist in a virtual environment in a DVI environment Bug patch that causes an error when exporting

5. Bug patch that causes afterimages to remain when there are no records in the grid in a VDI environment

6 SQL history sorting error patch

7. Fixed the phenomenon that some records are not visible when the grid is resized

8. Fixed the phenomenon that blinks when the session is changed

9. Fixed the phenomenon that blinks when the editor tab is changed

10. Focus error patch when executing F5 in the grid tab

11. Error patch when pressing the cancel button when changing the server character set

12. Export error patch when there is no folder when exporting data

13. GDI error patch when setting Grid mode in the grid

14. Handled so that driver errors do not appear at startup when the printer driver is not set correctly

1. Bug patch where highlight keywords do not work properly

1. Patch error when compiling function
Error message> unterminated dollar-quoted string at or near "$function$

1. You can encrypt the PostgreSQL connection between SQLGate and the PostgreSQL DB instance using SSL

patched the error that prevented connection with the error message below.

no pg_hba.conf entry for host ..

1. Bug patch where colors are not displayed correctly when columns are sorted in the new connection window

2. Import data > Excel file > Change the default value to not select automatic column mapping when UPLOAD

1. Patch AV error when closing last tab in SQL editor

1. Patch for bug that does not enable subquery block execution

2. Patch for bug where OCI/Net Login tab does not open as last environment

3. Improved data import speed. Speed ​​improvement of more than 10 times when executing updates when importing data

4. Bug patch that prevents DBMS_OUPUT results from being retrieved

1. Patch for bug where duplicate connections are intermittently displayed as existing connection information

2. In the actual execution plan, set the record fetch option to “fetch all records”

1. Patch for bug that does not display when number of records is 0 after SELECT

2. Patch for bug where actual execution plan and AWR report do not work properly
3. Patch for bug where ) in (a) is not closed in auto close
4. Patch for bug where special character auto-close option does not work properly

1. Changed the function to maintain records in the data tab after executing the execution plan

2. Patch for bug where multilingual characters are not saved in SQL history

3. Change the window so that it does not close even after the session is terminated.

1. Improved function to prevent other functions from running while a query is running

2. Show in progress icon in editor tab when query is running

3. Speed ​​improvement through editor deletion of binding variables

4. Added the ability to change tab names on the main taskbar

5. Improved function to allow access to the same session

6. Added session name duplication function when the same session connects

7. Speed ​​improvement by removing user analysis function

8. Patch where workspace is not saved correctly when connected to multiple databases at the same time

9. Patch for bug where SQL editor tab leaves an afterimage when session is changed

10. Patch for a bug that leaves an afterimage when there is one session and the session is closed

11. When connected through multi-session, patches are not selected at once when moving to another session's tab.

12. Patch for bug where editor font changes after pressing Tools>Options>Editor Options>Ok

1. Patch for a bug that leaves an afterimage in the work window when disconnecting a single session

2. Improved slowdown in binding variables with many binding variables

3.Patch for bug where table autocompletion does not change when there is more than one session

4. Improved screen switching speed when switching sessions

1.Remove the main title bar

2.Improved workspace loading speed

3. Add brief layout, theme, and option menu

4.Improved autocompletion speed in SQL editor

5.Improved automatic closing of special characters in SQL editor

6.AV error patch when entering “..” in SQL editor

7. Modify the CHAR and VARCHAR keywords so that () does not appear automatically in the SQL editor.

8.Set scroll font size as default in SQL editor options

9.If the column type is NVARCHAR, do not use CHAR, BYTE keywords

10. Ability to add Indent when executing a code template if the template has more than one line

11. Add parameter auto-completion option - Add general function hint function

12.Improved speed of retrieving the first record for tables with many columns

13. Patch for a bug where the read-only option does not log in in security tools such as DBSafer and QueryPie.

14.Patch for bug where COLUMN <> NULL is displayed when filter is set to COLUMN IS NOT NULL

15.Patch for a bug where when you Ctrol+Click a package in a package.function, the package is recognized as Owner and the package cannot be found.

16.Bug where the DEFINE command does not work properly

17. Bug where the editing window disappears when connecting/disconnecting the DB alternately

18. AV error patch when entering “..” in SQL editor

19.Patch for a bug where the editor’s menu bar does not appear consistently when using a simple layout

20. Patch for a bug where the window would not close intermittently in Options and Editor Options.

1. Make the Windows title bar invisible

2. Patch for a bug where lists of tables, views, etc. are not visible in the object report in CUBRID 11.2 version.

3. Patch for bug in CUBRID 11.2 version where lists of tables, views, etc. are not visible in script export

4. Patch for a bug where lists of tables, views, etc. are not visible in ER Design in CUBRID 11.2 version

1. Provides auto close of special characters in editor options

1. Provides auto close of special characters in editor options