KeepTool 12

We are proud to announce the release of KeepTool’s 12th edition. With over 50 improvements and a visual overhaul of the interface, KeepTool 12 is one of our biggest releases yet.

Windows 10 Compatibility

All KeepTool 12 client editions now run on Microsoft Windows 7, 8.1 and 10 and the corresponding server versions: 2008 release 2, 2012, 2012 release 2 and 2016.

KeepTool Free

Our new Free Edition consists of Hora Free—the compact successor to Hora Light that has been designed for end users who are focused on data entry, mining, and reporting.

Improved Oracle Spatial Support

Oracle Spatial support has been improved. We have added maintenance of spatial indexes, coordinate system changes including data transformation, configuration of the bounding rectangle and automatic creation of comments for MDRT tables implicitly created by Oracle.

New Oracle 12c Features

We continue to add support for new Oracle 12c features. For example, KeepTool 12 now supports the EXPLICIT NULLS clause, invisible columns and Oracle identity columns.

Visual Facelift

KeepTool 12 introduces a new look and feel. All button images have been repainted to blend seamlessly into Google’s new Material Design standard. The skinned user interface is now enabled by default, showing fewer edges and lines than before.

Over 50 Improvements

Many pages, particularly in Hora, have added new functionality. The Release Notes for Version 12 provide a complete list.

KeepTool Features

Current version: - updated 07/Sep/16


Hello, and welcome once again to our quarterly KeepTool newsletter, Keeping in Touch. In this issue, we’ll be highlighting a few of the new features that were introduced with Version 12.1.1, which was released in September 2016. KeepTool 12.1.1 is entirely compatible with Windows 10 Anniversary Edition. Support for NLS_LENGTH_SEMANTICS on the PL/SQL Page A … Continued

KeepTool 12.1 released

July 18, 2016

Welcome to the KeepTool newsletter for July, 2016. This month, we are pleased to announce the release of KeepTool Version 12.1.0. The new version offers several ways to simplify your coding efforts, as well as the addition of a “license borrowing” function for network licenses. New “license borrowing” function for using KeepTool 12 outside the … Continued

If your table has a foreign key to a master table, it is always a good idea—although not required—to have an index on the foreign key column to improve performance. If you should find situations where the index is missing, it’s easy to create it with Hora. Here we’ve cloned the HR schema into HR1 … Continued

KeepTool 12 released

March 1, 2016

We’d like to introduce you to KeepTool 12, which offers additional support for Oracle 12c as well as for the depiction of Oracle Spatial data. We’ve also instituted a new, easier licensing process and made the user interface blend in with Google’s Material Design standard.

In Version 12, Hora Light, our compact version of Hora for end users, has been renamed Hora Free, and as its name says, it is absolutely free to download and distribute.

Please continue reading to learn more about KeepTool 12.

KeepTool provides many useful functions for working with spatial data. By creating KML files, you can quickly show spatial data on a map. What’s more, Hora facilitates the configuration of maintenance operations for spatial columns.

Release Notes

  • DB Compare now generates UPDATE scripts that use ALTER TABLE commands instead of re-creating the table with changed structure.
  • DB Compare’s overview now shows an “Update Action” instead of the former “object change status”. This action describes how to consolidate the DB schemes rather than pointing out the difference between them.
  • A new checkbox option on Reverse/DB now allows you to check/uncheck whether CREATE TABLESPACE commands will be created.
  • Compile and Refresh menu items on Hora’s Materialized View page now have been enabled for multi-select.
  • Hora’s “Clear Schema” main menu item now truncates temporary tables before dropping to prevent ORA-14452 error.
  • The Reverse/DB tool now generates Oracle Contexts implemented by the DB schema, if the user has been granted select privileges on DBA_CONTEXT, granted by HORA_USER role, maybe.
  • Reverse/DB now orders the generation of views, materialized views, procedures, functions and packages by object dependency. As a result, there may be multiple sections for each object type, one for each level of dependency. By unchecking an option, you can get back to alphabetic order as before.
  • Scheduler jobs are now supported by Hora’s “show DDL” command, Reverse DB Engineer and DB Compare tool.
  • Support for Windows 10 Anniversary Update has been added. CodeMeter 6.30d runtime makes sure license are repaired, since the Anniversary update is actually a reinstallation of the operating system.

  • On both PL/SQL and Tables | Triggers views, you can see red bullets in the gutter area for each error position. We added a view bar to the right of the editor window that visualizes the relative error positions within the source text by red markers. The part of source code currently visible in the editor is indicated by a gray bar that moves while scrolling the editor.
  • New page Database | ACLs for managing access control lists (ACLs).
  • In all editor windows, you can now use Shift+TAB as a shortcut to the block indent command (button and menu item).
  • On PL/SQL page, you can navigate to another procedure or function implementation within the same package body by Ctrl-clicking a procedure call.
  • Added new column “NLS length semantics” to the PLSQL overview page.
  • Added “PL/SQL object settings” band to the Types overview grid including “NLS length semantics” column and other columns known from PL/SQL page.
  • Added context menu items to DB-Compare’s object list for printing and Excel export.
  • Reverse/DDL now generates NLS_LENGTH_SEMANTICS setting.
  • DB Compare’s experimental update script now contains only changes to objects that are selected using the check box next to the object name.
  • CodeMeter 6.30b runtime. See for change log.
  • Reverse/DDL now includes Java source.
  • Improved display of bullets to distinguish public from private methods on PL/SQL page.

  • Now you can borrow/return a network license seat on your client. For a limited time, it allows you to use KeepTool offline. Therefore, either run “License Manager – Borrowing” from the Windows start menu, or “Help|License Management|License Manager / Borrowing” from Hora’s main menu. Options for borrowing can be configured on the license server using CodeMeter WebAdmin. Please don’t forget to update your network license server to make sure it runs CodeMeter 6.20a or newer.
  • The modal dialog for creating and changing views now shows a toolbar with operations that had been available on the editor’s context menu only.
  • The source code window on the PL/SQL page now shows a red bullet near erroneous source code lines.
  • Main menu item “Help | License info“ now shows output captured from CodeMeter cmu32.exe utility.
  • On Oracle 10g database or later, the “resize datafile” dialog suggests purging the tablespace’s recycle bin before downsizing a data file.
  • The “synonym owner” dropdown list on the “create synonym” dialog now uses bold fonts for owners of existing synonyms or grants.
  • Added query builder and SQL*Plus execution buttons to separate SQL editor HEdit.exe. These actions formerly have been available as context menu items only.
  • Both DB object browser window and column selection dialog (that comes up for example when using the “Selected object | expand …” menu items) now use blue font for mandatory columns.
  • Tooltip hints for table comment and column description in DB object browser.
  • Dockable windows remember “undocked” status for next start.
  • Added a menu for “check all and “uncheck all” combo boxes to the confirmation dialog for operations on a multi-selection, such as “Drop user”.
  • A new Findpanel has been added to both Data content and SQL resultset grids. When memory mode is active, all occurrences of the search text in any column are highlighted in the grid view.
  • Hora’s now SQL remembers the :parameter and &macro values for the database connection string beyond end of session.
  • There is a new option on the data content tab for including the ORA_ROWSCN pseudo column in the SELECT statement that populates the data grid. Oracle doesn’t allow this pseudo column to be used in conjunction with tables having a virtual private database policy. The new option lets you decide to select ORA_ROWSCN pseudo column always, never, or automatically if the table has no policy function. Whereas the latter choice is the most convenient, the other options perform better. Remember, both ROWID and ORA_ROWSCN columns are selected but invisible by default and can be showed using the column selection tool in the upper left of the data grid.
    • On Tables page, menu “Copy to clipboard|XXX statement”
    • In editor windows, menu “Selected object, expand XXX statement”
    • In editor windows, DB object browser, drag-drop target menu, XXX statement now share the same column pre-selection dialog and SQL generation engine. For INSERT statements, there is a new option “default values” that adds rather default values or NULL values (for optional columns) to the VALUES clause than formal “:” variables, that are still used for mandatory non-default columns..
  • For the “execute script” command, the editor component now positions the input cursor to the SQL error position similar to “execute query”.
  • Information shown in tooltip hints for data grid headers, DB object browser and SELECT/INSERT/UPDATE SQL generators is now cached.