Enhancements for PL/SQL development

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

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


Index support for foreign keys

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

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.


Working with Oracle Spatial

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.


SQL and the Windows clipboard

Welcome to the latest issue of KeepTool’s Newsletter, Keeping in Touch. As we promised in our November 2014 issue, we are going to continue with a short series of articles that illustrate the most important features of KeepTool 11. This time, we’ll discuss a fundamental capability, namely the generation of SQL statements—something that KeepTool 11 handles in a smooth and elegant manner.



Shift + Ctrl + E(xcel)

The ability to export data to Microsoft Excel has long been a compelling feature of KeepTool, available through both a speed button and a context menu item.

We will take a deeper look into how this works later in this article.


Using KeepTool’s Mutating Table Trigger Wizard

Welcome to the second 2014 issue of the KeepTool newsletter, Keeping in Touch. In this issue, we’ll explore in depth how compound triggers, introduced in Oracle 11g, can help solve the “mutating table” problem, when an attempt is made to reference data in a table that is being updated. Coding a compound trigger involves some new coding twists; a new wizard takes care of these for you.


Version 11 released

In this issue, we’ll tell you a little bit about KeepTool 11, which changes a few things about how our products are packaged and licensed. With Version 11, KeepTool now comes with separate setup files for 32-bit and 64-bit Windows operating systems. As far as the product suite goes, we’ve not only added a new tool, DB Compare, to our offerings — more about this appears below — but we’ve also structured our offerings into 3 editions to simplify the decision of which one best fits a particular user’s needs.

As far as the product suite goes, we’ve not only added a new tool, DB Compare, to our offerings — more about this appears below — but we’ve also structured our offerings into 3 editions to simplify the decision of which one best fits a particular user’s needs.