SQLGate for Oracle Developer 8.3.0.0

Updated: Dec-12-2017

Updates

Improved performances:

1. New function added: Object Preview
   
   
   1. Go to Tools>Options>SQL Editor> Editor Option>AutoComplete>Object Preview. It is set as default.
   2. Press Ctrl key and place the cursor on the object in the editor. Object preview will be given as shown below.
      
      • Table Preview
        
        Column: Click to view table column details
        View Record: Click to view table record
        Open Description Pane: Click to open description pane
      • Package Preview
        
        Modify: Click to modify on PL/SQL Editor
        Run: Click to open Run window
        Open Description Pane: Click to open description pane
      • Procedure/Function Preview
        
      • Modify: Click to modify on PL/SQL Editor
        Run: Click to open Run window
        Compile: Click to open Recompile Object window
        Debug: Click to open PL/SQL debugger
        Open Description Pane: Click to open description pane
2. New feature added upon double-clicking grid
   
   
   1. Run and Modify Current SQL
      => It allows record to be modified on the spot.
   2. Send to SQL Editor
      => It copies cell data from grid and pastes on SQL editor
3. New feature to select either to use/not use navigator on PL/SQL Editor
   
4. New feature to select and double-click procedure or function in the packages on object panel to move to the selected procedure or function
   
5. An option added to select Byte/Char on New Column window
   
6. Comment added on DESC command
   
7. LOB Storage Attributes added on table script output
8. Include CHAR | BYTE feature added on table script output
   
9. Field autocomplete feature added
   
   As in the image shown below, upon field autocompletion and then selecting a field, field name AS "Comment" option added
   
10. Code Preview feature added
    As in the image shown below, the location of the same keyword for the selected text will be shown on the scrollbar. Place the cursor to preview.
    
11. Make Alias
    Enter new connection detail. When successful, an alias can be made for the connection and for the session.
    

Patch

1. Fixed bug that changes the display into the theme color after editor background color is set
2. Fixed bug that does not display the total number of tables on Oracle EXP Utility
3. Fixed bug of blinking cursor when pressing ctrl key and moving the cursor over to the object on PL/SQL Editor
4. Fixed bug that incorrectly selects objects loaded on F4 description pane on the editor
5. Fixed bug in which window did not close when database server connection lasts long due to network traffic
6. Fixed bug that does not display the package body on the object panel for users with a privilege to SELECT ANY DICTIONARY
7. Fixed bug that does not change character type fields from Byte to Char when altering tables
8. Fixed bug where ERD design button remains clicked/pressed
9. Fixed bug that does not change column information when clicking Refresh Object on ERD Design
10. Fixed bug that gives message “Program does not respond” when PL/SQL Debugger is cancelled.