KeepTool 16.2.2

10 Apr 2025

• KeepTool 16.2.2 improves Oracle SQL*Plus compatibility. INSERT script lines containing spatial data are now split into multiple lines, each less than 2000 characters long.
• There are two changes to the Container Databases page:
  • Up to this version, the last tab on the CDB page showed the properties of the currently selected Oracle container database.
    You could not see properties of another CDB before switching the container.
    KeepTool 16.2.2 now shows the properties of all CDBs side by side, making it much easier to compare PDB settings.
    PDB properties differing from the value of the root container are highlighted.
  • Up to this version, the CDB tablespace tab displayed a checkbox that indicated the tabespace is used in the appropriate CDB.
    KeepTool 16.2.2 replaces the checkbox with the sum of MBytes used from the CDB.
• Since KeepTool 16.1.0, the tables overview page contains a menu item to create “DDL for PostgreSQL Database.”
  In this version we introduced a similar menu item for Microsoft SQL Server Database.
  For the time beeing, the new feature is tagged as ‘experimental’.
• The ‘Change column order’ dialog is available in the context menu of both Data Content and SQL Query Resultset grids.
  In KeepTool 16.2.2, the dialog got a couple of changes:
  • The dialog now remembers its size.
  • Required columns are displayed in blue font, primary and unique key columns bold; similar to how columns are displayed in several data grid views.
  • Next to each column, the dialog displays an icon that visualizes the column’s data type.
  • The dialog now displays a tooltip window showing the column’s data type and column comment,
    if the ‘settings | data content | show active tooltips in grid view’ setting is active.
• The ‘copy to clipboard’ menu item on the tables context menu has been renamed to ‘Generate code’.
  The column selection dialog for the SELECT/INSERT/MERGE statement to be generated now displays data type icons next to the column names.
• KeepTool 16.1.0 introduced a new data grid on the right of the tables | master/detail view. It shows column names and data types for the mouse-over table.
  KeepTool 16.2.2 now also shows column comments. To put more focus on the comments, we advise to resizing the data grid area and giving it a little bit more space.
• The Create INSERT/UPDATE/MERGE script dialogs now allow you to define replacement expressions for a choice of columns.
  The basic idea is, for example, you may wish to fill a column value from a sequence rather than having primary key values included in the script.
  The dialog allows you to specify one or more pairs of column name and replacement expression, such as a primary key column and the expression SEQUENCE_NAME.NEXTVAL.
  The dropdownlist includes several suggestions for replacement expressions, but you are free to enter your own value manually.
• The ‘Show DDL’ command for users now prompts you for several options what to be included into the script or excluded.
  The dialog remembers your choice for the next usage.
• The Hora dialog for selecting table columns is displayed when creating DML statements such as INSERT, UPDATE or MERGE SQL
  The lower part of the dialog shows a series of buttons that can be used to check or uncheck several table columns at once.
  Hora 16.2.2 adds a few more options to check or uncheck multiple columns at once. In total, Hora now offers the following options:
  • Check All Columns, Required Columns, Primary and Unique Key Columns, or Indexed Columns
  • Disable all columns, columns with default values or columns calculated by trigger logic.
• Reverse DB got a new checkbox option ‘Always prefix object names with schema name’. When unchecked (default) the logic applies as before, i.e. schema prefixes are included for objects outside of the current schema only.
  A similar checkbox “Always include schema prefix in ‘Show DDL’ command” has been added to Hora’s Settings | Behavior page. It affects the Show DDL dialog.
  The option has been added because some users prefer running scripts always as SYS.
• The font of the data type symbols has been reduced to semi-bold in order to achieve a lighter appearance.
• KeepTool 16.2.2 renders vector-based skins faster. That is especially noticable for the WXI skin.
• The setup installs Wibu CodeMeter runtime version 8.20a. It is strictly recommended to update the CodeMeter runtime, especially on your network license server. Download the runtime setup from https://www.wibu.com/support/user/user-software.html .

See how it works!

Explore possibilities of KeepTool.

Try for free

Try KeepTool now!

KeepTool’s Oracle database tools have been developed by database application developers for database application developers as well as database administrators and application support. Based on the feedback and requests of our customers, we have been continuously improving our tools for more than 20 years and strive to improve with each new release.

Download KeepTool