oracle

KeepTool Blog

Browsing database connections by host name

08 Mar 2020

Each of our tools comes up with a connect dialog that displays most recent connections. This list can be organized by History, i.e. most recently usage Database, i.e. either TNS alias or hostname:port/servicename for direct TCP/IP connections User, i.e. database user Custom category, i.e. your own predicate you can assign to each session In the […]

KeepTool ER Diagrammer – A powerful tool improved again in version 14.1

16 Dec 2019

The ER Diagrammer is part of the KeepTool Enterprise edition. In an instant, the tool creates a properly arranged Entity-Relationship Diagram by reverse engineering your database. This is very useful for data modelling, understanding an unknown legacy database, and for documentation purpose. The new ER Diagrammer comes up more flexible with a customizable diagram subset [...]

KeepTool Reverse Database Engineer – New features introduced in version 14.1

08 Oct 2019

Reverse DB is part of both KeepTool Professional and KeepTool Enterprise editions. Since all our tools benefit from our continual improvement strategy, version 14.1 comes with an important new feature. Reverse DB allows you to create a DDL script for an existing database schema or any subset of selected objects. That is a very powerful […]

KeepTool Hora analyses session blockades at dataset level

26 Apr 2019

If a database session blocks a dataset for an extended period of time, this can have highly negative consequences – even affecting a productive system in the worst case. It is therefore very important to quickly identify the cause behind such a blockade. With Hora, KeepTool’s most important Oracle tool, it has always been possible […]

KeepTool’s interactivity with MS Excel grows more powerful

01 Feb 2019

Over the last years, KeepTool has developed powerful import and export functions to make the use of Excel files in combination with Oracle databases as convenient as possible. In the latest edition, version 14, these features have been enhanced through additional useful functions. KeepTool thereby offers comprehensive functionality when working with Excel files. Excel exports […]

Master/Detail view in data browser

16 Nov 2018

Whereas you can use a master/detail view on the tables | data content page for years now, the data browser left you behind with a single table view. ‍The good news is, in KeepTool 14 you have a master/detail view for each page of the data browser. In the details view, you can tab-switch between […]

Optimized Excel export for grouped data and totals

30 Sep 2018

The data content browser shows data of the COMPANY table within the HR schema. To enable enhanced grouping capabilities, we activated the “in-memory grid mode” by clicking the appropriate checkbox in the top-right of the data content frame. Data is grouped by CITY by dragging the appropriate column header into the group-by box in the […]

Merged Column Grouping in data browser

15 Aug 2018

In the top right of the Data Browser, you find the checkbox “in-memory grid mode”. It enables a couple of enhanced filtering and browsing capabilities by loading the entire grid content into memory. ‍ KeepTool 14 now introduces a nice enhancement to the group-by mode. As of KeepTool 12, you can drag a column header [...]

KeepTool now with more than 40 new features and numerous improvements

25 Jun 2018

KeepTool is considered a Swiss Army knife for administrative and programming tasks related to Oracle. The software supports all Oracle features, and its use is self-explanatory and incredibly simple. “Time and time again, our users confirm that they find their bearings immediately and are able to use all functions straight away, even without a manual,” […]

Execute Reverse DB from a batch file

09 Feb 2017

In this example, we would like to show you a sample how to use a Windows batch file to execute the Reverse DB Engineer on a regular basis and store each resulting script as a date-stamped file for future reference. Note the RevDDL executable has been passed two parameters: the name, including path, of the […]

Avoiding character set conversion pitfalls when migrating to Oracle 12c

08 Feb 2017

Over the course of the past year 2016, some of our customers have shared with us their experiences with database migration to Oracle 12c. In most cases the customers installed a new pluggable 12c database rather than upgrading the existing database. After that, they transferred data using export and import utilities. ‍ One issue that […]

Running an initialization script after connecting to the database

07 Feb 2017

KeepTool 12.1.3 introduced the ability to designate an initialization script to run immediately after logging on to Hora. For each database connection, an initialization script can be set in the expanded section of the Connect dialog window: Although you may already have some ideas in mind for using this feature, we’d like to mention two […]

KeepTool 12.1 released

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

Index support for foreign keys

08 Jun 2016

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

KeepTool 12 released

01 Mar 2016

Hello again and welcome to the March 2016 issue of the KeepTool newsletter, Keeping in Touch.In this issue, 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 […]

Working with Oracle Spatial

30 Jun 2015

Oracle Spatial provides powerful features for working with spatial data such as points and polygons. It is implemented in the MDSYS schema. As long as you have licensed Oracle’s spatial option, KeepTool can help you take full advantage of it. Let’s start Hora and connect to the OE sample schema. The CUSTOMERS.CUST_GEO_LOCATION column instantiates the […]

SQL and the Windows clipboard

13 Mar 2015

The SQL Query Generator Building SQL statements is among the most common tasks that an Oracle developer is faced with. In this newsletter, we will explore some approaches that let the developer do this in a more efficient manner. For joining multiple tables, you can use KeepTool’s Query Builder, which you can access from any editor window by clicking the construction-site icon: [...]

Shift + Ctrl + E(xcel)

11 Nov 2014

Data Export from Oracle to Excel 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. Were you aware that in our latest version, […]

Using KeepTool’s Mutating Table Trigger Wizard

29 Sep 2014

An example of the Mutating Table Error (ORA-04091) Here is an example showing how Hora’s Mutating Table Trigger Wizard can come in handy to solve the mutating table error. One situation in which this could happen is when an attempt is made to update an aggregate amount in a master table, based on DML operations [...]
keeptool11_dbcompare

Version 11 released

17 Feb 2014

KeepTool now comes in 3 editions: Light, Professional and Enterprise. We’ve realigned our product suite by packaging our current lineup of executable programs into one of 3 packages, each of which is targeted at a specific user group. KeepTool Light Hora Light is our end-user adaptation that has been available as a licensed product since [...]

Browsing database connections by host name

08 Mar 2020

Each of our tools comes up with a connect dialog that displays most recent connections. This list can be organized by History, i.e. most recently usage Database, i.e. either TNS alias or hostname:port/servicename for direct TCP/IP connections User, i.e. database user Custom category, i.e. your own predicate you can assign to each session In the […]

KeepTool ER Diagrammer – A powerful tool improved again in version 14.1

16 Dec 2019

The ER Diagrammer is part of the KeepTool Enterprise edition. In an instant, the tool creates a properly arranged Entity-Relationship Diagram by reverse engineering your database. This is very useful for data modelling, understanding an unknown legacy database, and for documentation purpose. The new ER Diagrammer comes up more flexible with a customizable diagram subset [...]

KeepTool Reverse Database Engineer – New features introduced in version 14.1

08 Oct 2019

Reverse DB is part of both KeepTool Professional and KeepTool Enterprise editions. Since all our tools benefit from our continual improvement strategy, version 14.1 comes with an important new feature. Reverse DB allows you to create a DDL script for an existing database schema or any subset of selected objects. That is a very powerful […]

KeepTool Hora analyses session blockades at dataset level

26 Apr 2019

If a database session blocks a dataset for an extended period of time, this can have highly negative consequences – even affecting a productive system in the worst case. It is therefore very important to quickly identify the cause behind such a blockade. With Hora, KeepTool’s most important Oracle tool, it has always been possible […]

KeepTool’s interactivity with MS Excel grows more powerful

01 Feb 2019

Over the last years, KeepTool has developed powerful import and export functions to make the use of Excel files in combination with Oracle databases as convenient as possible. In the latest edition, version 14, these features have been enhanced through additional useful functions. KeepTool thereby offers comprehensive functionality when working with Excel files. Excel exports […]

Master/Detail view in data browser

16 Nov 2018

Whereas you can use a master/detail view on the tables | data content page for years now, the data browser left you behind with a single table view. ‍The good news is, in KeepTool 14 you have a master/detail view for each page of the data browser. In the details view, you can tab-switch between […]

Optimized Excel export for grouped data and totals

30 Sep 2018

The data content browser shows data of the COMPANY table within the HR schema. To enable enhanced grouping capabilities, we activated the “in-memory grid mode” by clicking the appropriate checkbox in the top-right of the data content frame. Data is grouped by CITY by dragging the appropriate column header into the group-by box in the […]

Merged Column Grouping in data browser

15 Aug 2018

In the top right of the Data Browser, you find the checkbox “in-memory grid mode”. It enables a couple of enhanced filtering and browsing capabilities by loading the entire grid content into memory. ‍ KeepTool 14 now introduces a nice enhancement to the group-by mode. As of KeepTool 12, you can drag a column header [...]

KeepTool now with more than 40 new features and numerous improvements

25 Jun 2018

KeepTool is considered a Swiss Army knife for administrative and programming tasks related to Oracle. The software supports all Oracle features, and its use is self-explanatory and incredibly simple. “Time and time again, our users confirm that they find their bearings immediately and are able to use all functions straight away, even without a manual,” […]

Execute Reverse DB from a batch file

09 Feb 2017

In this example, we would like to show you a sample how to use a Windows batch file to execute the Reverse DB Engineer on a regular basis and store each resulting script as a date-stamped file for future reference. Note the RevDDL executable has been passed two parameters: the name, including path, of the […]

Avoiding character set conversion pitfalls when migrating to Oracle 12c

08 Feb 2017

Over the course of the past year 2016, some of our customers have shared with us their experiences with database migration to Oracle 12c. In most cases the customers installed a new pluggable 12c database rather than upgrading the existing database. After that, they transferred data using export and import utilities. ‍ One issue that […]

Running an initialization script after connecting to the database

07 Feb 2017

KeepTool 12.1.3 introduced the ability to designate an initialization script to run immediately after logging on to Hora. For each database connection, an initialization script can be set in the expanded section of the Connect dialog window: Although you may already have some ideas in mind for using this feature, we’d like to mention two […]

KeepTool 12.1 released

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

Index support for foreign keys

08 Jun 2016

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

KeepTool 12 released

01 Mar 2016

Hello again and welcome to the March 2016 issue of the KeepTool newsletter, Keeping in Touch.In this issue, 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 […]

Working with Oracle Spatial

30 Jun 2015

Oracle Spatial provides powerful features for working with spatial data such as points and polygons. It is implemented in the MDSYS schema. As long as you have licensed Oracle’s spatial option, KeepTool can help you take full advantage of it. Let’s start Hora and connect to the OE sample schema. The CUSTOMERS.CUST_GEO_LOCATION column instantiates the […]

SQL and the Windows clipboard

13 Mar 2015

The SQL Query Generator Building SQL statements is among the most common tasks that an Oracle developer is faced with. In this newsletter, we will explore some approaches that let the developer do this in a more efficient manner. For joining multiple tables, you can use KeepTool’s Query Builder, which you can access from any editor window by clicking the construction-site icon: [...]

Shift + Ctrl + E(xcel)

11 Nov 2014

Data Export from Oracle to Excel 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. Were you aware that in our latest version, […]

Using KeepTool’s Mutating Table Trigger Wizard

29 Sep 2014

An example of the Mutating Table Error (ORA-04091) Here is an example showing how Hora’s Mutating Table Trigger Wizard can come in handy to solve the mutating table error. One situation in which this could happen is when an attempt is made to update an aggregate amount in a master table, based on DML operations [...]
keeptool11_dbcompare

Version 11 released

17 Feb 2014

KeepTool now comes in 3 editions: Light, Professional and Enterprise. We’ve realigned our product suite by packaging our current lineup of executable programs into one of 3 packages, each of which is targeted at a specific user group. KeepTool Light Hora Light is our end-user adaptation that has been available as a licensed product since [...]