oracle

KeepTool Blog - Current

Grouped Oracle data view

Oracle Excel grouping retained in export and computed totals

30 Sep 2018

Data grouping withing Oracle Excel export now can be retained. As you may rememeber, column groupings are available both in Hora’s data content browser and SQL result set view. 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 […]

Oracle data view grouped hierarchy

Oracle merged column grouping in data content browser

15 Aug 2018

KeepTool 14 Data Content Browser now introduces Oracle merged column grouping. In the top right of the Data Content 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 [...]
Oracle master detail data view

KeepTool 14 new features and enhancements

25 Jun 2018

KeepTool 14 comes with more than 40 new features and numerous enhancements KeepTool is considered a Swiss Army knife for administrative and programming tasks related to Oracle databases. 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 […]

Oracle SQL initialization script

Oracle database structure backup

09 Feb 2017

Oracle database structure backup and how it can be established will be discussed in this article. 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 […]

Find Oracle columns that would exceed byte length in multi-byte character set

Oracle 12c migration and how to avoid character set conversion pitfalls

08 Feb 2017

Oracle 12c migration experiences some of our customers have been shared with us over the course of the past year 2016. 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 stood out was […]

Oracle SQL initialization script

Oracle initialization script

07 Feb 2017

KeepTool 12.1.3 introduced the ability to determine an Oracle initialization script to run immediately after logging on to Hora. For each database connection, an initialization script can be assiged 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 […]

PL/SQL source code editor

KeepTool 12.1 new features

18 Jul 2016

KeepTool 12.1 introduces numerous new features. 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 […]

Oracle explain plan viewer

Oracle foreign key index support

08 Jun 2016

Oracle foreign key index support means always having an index on your foreign key columns. 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, […]

Oracle spatial data map viewer

KeepTool 12 new features

01 Mar 2016

KeepTool 12 introduces various new features. 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, […]

Goolge Earth view of Oracle spatial data

Oracle Spatial features supported by KeepTool

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