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 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 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 […]
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 […]
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 […]
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 […]
