Oracle 7.3 - Oracle 21c Windows 11 compatible Version (Released: )

KeepTool Blog - Current

KeepTool favicon

KeepTool 14.2.3

14 Jul 2021

In KeepTool 14.2.3, the Schema | Policies page has got two new menu items to enable respectively disable an Oracle policy. For Oracle 18c and later, Hora now displays the database version including patch levels such as 19.10.0.0.0 by querying another Oracle data dictionary column. KeepTool now includes FastReports 2021 reporting system that introduces several [...]
KeepTool favicon

KeepTool 14.2.2

19 Apr 2021

In KeepTool 14.2.2 the Filter Box for in-memory filtering data grids now supports a new token-based style. This style helps end-users easily differentiate between colorized filter items and modify or clear individual filter conditions. The new style is also available in built-in Filter Builder dialog. The Schema | Policies data grid now shows detail information [...]
KeepTool favicon

KeepTool 14.2.1

23 Feb 2021

Access control lists are used to allow network communication from your PL/SQL code, sending emails for example. For managing access control lists using Horas database page, KeepTool 14.2.1 added the following privileges to both ‘Create ACL’ and ‘ACL privileges’ dialogs: http, http_proxy, smtp, jdwp. As you may remember, the “Find PL/SQL” dialog shows a button […]

KeepTool favicon

KeepTool 14.2.0

03 Dec 2020

KeepTool 14.2 adds Oracle 20c support The following dialogs now show a “reveal password” button inside the password box. It displays the password as clear text for the time the button is pressed. Create User Create Role Change Password Password Expiration The new option “Data content | Escape control characters in script” introduced in KeepTool14.1.6 […]

KeepTool favicon

KeepTool 14.1.6

14 Aug 2020

KeepTool 14.1.6 can now be installed using the new Windows Package Manager. You can now specify the character set, when saving CLob data to a file. There is a new menu item ‘Set Attributes …’ on the Oracle scheduler jobs data grid. It allows you to change selected job attributes. Improved Oracle PL/SQL profiler dialog […]

KeepTool favicon

KeepTool 14.1.5

28 May 2020

The SQL editor menu item "Query | Recall SQL from command history" allows you to retrieve a SQL statement from the history of up to 1,000 most recently executed SQL commands. As of KeepTool 14.1.5, the history includes both SQL statements executed explicitly on the SQL page, as well as SQL statements executed implicitly by [...]
KeepTool favicon

KeepTool 14.1.4

24 Feb 2020

An new 'Hostname' tab on the connect dialog provides access grouped by both hostname and servicename as remembered from last login. To avoid confusions, the hitherto 'Server' tab sheet has been renamed to 'Database'. Both 'Database' and 'Hostname' group captions include the Oracle database version number that as remembered from last login. Repeatedly connect again [...]
KeepTool favicon

KeepTool 14.1.3

09 Dec 2019

On the AWR SQL history page, Hora now displays the SQL execution plan in the code window right below the SQL text. The DB object browser on the right of the SQL editor window now allows incremental search. Just make sure the tree view is focused and start typing. Additionally, a new search box below […]

KeepTool favicon

KeepTool 14.1.2

24 Oct 2019

New context menu item ‘Cancel SQL’ on sessions overview page for Oracle 18c and later. New Oracle 19c reserved words added to syntax highlighting. If you drag-drop a procedure or function name from the DB object browser into the code editor window, a pop-up menu item allows you to insert an anonymous PL/SQL block that […]

KeepTool favicon

KeepTool 14.1.1

14 Aug 2019

The data content menu item/button “change column order” is now also available for the SQL query result set on the SQL page. Two new sub-menu items added to the  “Selected object” context menu of the SQL page: “Expand View name to SQL definition” replaces a selected view name by the SQL text of the view […]