KeepTool Blog - Current

A new facility for exporting the SQL results grid and table contents to a Microsoft Excel spreadsheet has been added.

A new facility for generating new user connections, and for switching new connections within Hora, has been added to the menu bar and to the Toolbar. Syntax highlighting for reserved words in code editing windows now includes more new 9i words. The Current Schema combo box in Hora has been expanded in length, and the […]

Enhancements to PL/SQL Debugger to maintain variable watches in triggers between invocations, and to enable variable watches in global package variables. In Reverse DDL, a new option determines whether the check-box list of database objects should appear checked or not checked when opening the application. When executing SQL from either the SQL Workbench’s code window […]

The Grant and Revoke modal dialogs, available on the Privileges tab of certain objects, now allow privileges to be granted to or revoked from multiple roles or users at the same time. Additional columns pertaining to Object Tables have been added to the Overview Tables sheet. The Oracle Online Documentation feature now offers access to […]

Automatic Code Completion can be enabled or disabled through the Extras menu item. Automatic Code Completion now completes an unfinished designator after a pause or Ctrl + space. If Enter is pressed, code completion resumes in the same case as the previously entered text. In SQL Workbench, root nodes on a network drive are now […]

Reverse DDL Generator now creates DDL for tablespaces, and is available through Hora’s context menu. The Overview Tablespaces sheet now includes the tablespace number. SQL Logging is now called SQL Recording, and can be toggled on or off through the Extras menu, as well as from the SQL Preview window. The SQL Repository is now […]

Changes to the Tables | Data Contents tab sheet The Create INSERT Script menu item now prevents all previously hidden columns from being included. This feature enables partial comparison of tables belonging to different databases. The new Create UPDATE Script menu item generates a similar script containing UPDATE statements. A new Logging context menu item […]

The new Resource Manager page presents an interface for managing the hierarchy of resource plans and associating them with consumer groups. You can define a default consumer group for a user and switch the consumer group for a session. The interface to Oracle’s auditing facility has also been improved. You can define audit options for […]

Added a new Visible Columns … context menu item to the data contents grid. It opens a modal dialog for changing the order and visibility of the columns. New Sessions | Transactions tab sheet. The headings on some data grids are now displayed and managed hierarchically. Related columns are now grouped together as subheadings under […]

In Hora, you can now right-click on any table to show the corresponding Create Table statement. Reverse/DDL now supports partitioned tables. The representation of table and index partitions in Hora has been improved. The connect dialog now allows you to choose either normal, sysoper or sysdba as the connect mode. This is required in order […]