SQLTools for Oracle Files

Read more about 1.7 in the forum http://www.sqltools.net/cgi-bin/yabb25/YaBB.pl?num=1316484769

STABLE

Version 1.7 build 58 (2016-09-16)
    Improvements:
    Bug fixes:
    - "Find Object" <F12> fails with EXCEPTION_ACCESS_VIOLATION 
    when Object Viewer "Use Cache" is ON while session "Object Cache" is OFF

Version 1.7 build 57 (2016-08-30)
    Improvements:
    Bug fixes:
    - added "ON DELETE SET NULL" for FK reverse-engineering

Version 1.7 build 56 (2016-05-09)
    Bug fixes:
    - Count query (Ctrl+F11) fails from Object Viewer if table/view selected w/o columns

Version 1.7 build 55 (2015-11-08)
    Improvements:
    - Highlighting all occurrences of selected word
    - Displaying full path in the status bar when an open recent file menu item is selected
    - Changed the way the mouse position is mapped to text postion.
      The cursor position will always move to the left of the character selected by mouse,
      previously the closest boundary was choosen.
    Bug fixes:
    - incorrect highlighting in lines stated with 's'

Version 1.7 build 54 (2015-09-28)
    Improvements:
    - implemented "Keep (connection) alive period", disabled by default (0 min)
    - added new editor command "Duplicate current line or selection" with default shortcut Ctrl+K,Q
    Bug fixes:
    - QuickQuery (F11) / QuickQCount (Ctrl+F11) do not work with multiline selection
    - Dbms_output spin control on Session settings page works incorrectly

Version 1.7 build 53 (2015-07-26)
    Bug fixes:
    - Save File: added FlushViewOfFile & FlushFileBuffers to force Windows to flush data to disk
    - QuickQuery (F11) ignores "NULL representation" setting in Data Grid 2

Version 1.7 build 52 (2015-01-27)
    Other changes:
	- removed the trailing <CR> from copy in tab-delimited mode.
          Hopefully nobody will complain about that.

Version 1.7 build 51 (2015-01-25)
    Bug fixes:
	- bug fix, explain plan view small navigation/focus issues

Version 1.7 build 50 (2015-01-21)
    Bug fixes:
	- bug fix, ObjectViewer compatibility issue with 10g

Version 1.7 build 49 (2014-10-15)
    Improvements:
	- new explain plan view
	- property view for explain plan view

Version 1.7 build 45 (2014-10-02)
    Improvements:
	- added a sql text to the error reporting
    Bug fixes:
	- bug fix, DDL reverse engineering compatibility issue with 11.1

Version 1.7 build 42 (2014-08-05)
    Bug fixes:
	- bug fix, "Compile" fails on "Types"/"Type Bodies" from "ObjetsList"

Version 1.7 build 41 (2014-06-30)
    Improvements:
	- added support for dbms_xplan. Taken from sqltools++ but it was altered.
	- added two properties to the Grid setting: "Headers in lowercase"
	  and "Wrap around cursor" (sqltools++)
	- "Count" from ObjectViewer is possible with selected columns as well:
	  select <selected columns>, count(*) from <table> group by <selected columns> order by count(*) desc

Version 1.7 build 39 (2014-06-23)
    Improvements:
	- added partitions/subpartitions to ObjectViewer (subject to change)
    Bug fixes:
	- bug fix, when Double-Click to close file with changes, file seems closed, but filename remain in workbook

Version 1.7 build 37 (2014-06-19)
    Improvements:
	- added "Quick query" and "Quick count(*)"
	- added "Query"/"Count" to ObjectViewer (it can show only selected columns)
	- The result of "Query"/"Count" from ObjectViewer / ObjetsList can be shown either
	  in a new document or in already open one (change in settings)
	- F11 key was re-assigned to run "Query"/"Count",
	  that is not final unless there is strong voice against that
	Not impleneted yet:
	- add an optional where clause to "query"/"count(*)"
	- add an alternative "SQL" context menu and let switch default context menu

Version 1.7 build 35 (2014-06-15)
    Improvements:
	- DDL reverse engineering handles sub-partitioning
    Bug fixes:
	- PROMPT with ' is not handled properly
	- DDL reverse engineering is not compatible with 8i

Version 1.7 build 27 (2014-05-29)
    Improvements:
	- DDL reverse engineering recognizes virtual columns and range-interval partitioning
    Bug fixes:
	- Keyboard shortcuts in "Objects Viewer" have been re-implementd because if their erratic behavior.
    - DB object highlighting is still active after disconnect.

Version 1.7 build 26 (2014-05-27)
    Bug fixes:
	- compile in "Invalid Objects" does not refresh object status

Version 1.7 build 25 (2014-05-26)
    Improvements:
	- Added "Invalid Objects" Tab to "Objects List"
	- Added duration to SQL history
	  ATTENTION: all persistent history files will be converted to the new format
	  and will be ignored by SQLTools 1.6!
    Bug fixes:
	- All Alt key + (0, 1, 3 & 4) do not work whenever Object Viewer is in focus.
	  I want to see how this fix works. if it does not cause any problem,
	  I will make similar changes in "Objects List" and "File Manger".
	- Object Viewer does not work when 'Use Cache' option is selected with slow network option.

Version 1.7 build 24 (2014-05-19)
    Improvements:
    Bug fixes:
	-Autocomplete for package procedures does not work

Version 1.7 build 23 (2014-05-18)
    Improvements:
	- ObjectViewer is finalized,
	  hopefully I will need only to add new stuff as partition/subpartition info
	- Addded "Load DDL with Dbms_Metadata", the shortcut is Alt+F12
    Bug fixes:

Version 1.7 build 21 (2014-05-12)
    Improvements:
	- New ObjectViewer look, tree lines have been sacrificed
      in favor of colunm formatted datatypes.
    Bug fixes:
	- cannot load index DDL form ObjectViewr

Version 1.7 build 20 (2014-05-12)
    Improvements:
	- Removed RULE hint from DDL reverse engineering for server versions >= 10g
    Bug fixes:

Version 1.7 build 19 (2014-05-11)
    Improvements:
    - Autocomplete (objects, table column / package procedures)
    Bug fixes:
    - template changes are not available for already open files
    - read-only connection does not allow explain plan
    - commit command is not disabled in read-only mode
    - read-only connection asks about commit/rollback on close

Version 1.7 build 16 (2014-04-27)
    Improvements:
    - Implemented REFCURSOR and DATE bind variables.
	  The last one is not supported by Oracle SQL*PLus,
    Bug fixes:

Version 1.7 build 15 (2014-04-20)
    Improvements:
    - ObjectViewer has been re-implemented (drag-drop has been improved)
    Bug fixes:
    - suppressed unnecessary object name cache reload (for editor highlighting)
      on any setting change anymore.
    - Win7 compatibility issue with multi item selection in ObjectViewer