KeepTool 16.1.0

    Published 23. April 2024

    Data Content & SQL Query Enhancements

    • Both Data Content and SQL Query grids now automatically hide the filter row when the result set is empty.

    • Menu items for INSERT, UPDATE, MERGE, and DELETE script generation now open an options dialog that lets you:

      • Preview and customize script settings.

      • Choose between “Save to file” or “Copy to clipboard.”

      • Save your current settings as defaults for later use (also configurable in the global Settings dialog).

    • In the “Change column order” dialog, selecting a column name now:

      • Focuses the column in the underlying grid, and

      • Highlights it in KeepTool 16.1.0—making it easier to locate columns by name.

    Oracle Compatibility

    • Added support for the BOOLEAN data type introduced in Oracle 23ai.

    • For direct TCP/IP connections, the default IP type has been changed from IPv4 only to IPv4/IPv6 dual mode.

      • You may revert to IPv4-only if required.

    PL/SQL Types Page

    • Overview Grid:

      • Now includes additional checkbox columns and displays supertype information.

    • Menu Enhancements:

      • New options to modify properties such as FINAL and INSTANTIABLE.

    • Attributes Grid:

      • Displays data type information (including icons) similar to the Tables | Columns grid.

      • Added context menu items to add, modify, or delete type attributes.

    • Source Code Window:

      • Now includes a DB Object Browser, similar to the PL/SQL page.

    Constraint Exceptions Dialog

    • Previously: “Copy Query by Key Values” generated a SELECT with a WHERE … IN (…) clause based on key values.

    • New in 16.1.0: “Copy Analysis SQL” button that copies the exact SQL used to populate the data grid.

      • Ideal for developers—share with customers for direct execution in HoraFree or any Oracle SQL client.

    Data Content Browser

    • The tables list context menu now includes:

      • Truncate → Opens a dialog to truncate a table (delete all data without rollback).

      • Show DDL → Opens a dialog showing the DDL of a table, view, or synonym.

    Sessions Page

    • The “Lock Wait Graph” tab has been renamed to “Blocking Sessions.”

    • Now displays a multi-column tree view with more information about blocked sessions.

    SQL Page

    • New Resultset Window button has been replaced by “Execute Query in New Window.”

      • Executes the query and displays results in a new data grid.

      • A green icon marks the active window where result sets will appear.

    • New Format | Create UUID context menu item inserts a Windows GUID at the cursor position.

      • Shortcut: Ctrl+Alt+Shift+U.

    Flat Detail Data Browser

    • The tree view now shows the foreign key name for detail tables with multiple references to the same master table.

    Tables Page

    • “Move Tablespace” renamed to “Move.”

    • In the Move dialog:

      • Tablespace is optional for Oracle 12c Release 2+.

      • New options: Move online, update indexes, compression, logging.

    • Columns Grid:

      • Required columns now displayed in blue font.

      • Primary key and unique key columns in bold font.

      • New orange dot indicator shows which columns are indexed.

    • Constraints:

      • Defaults for new constraints set to “Deferrable, initially immediate.”

      • Generated DML scripts include SET CONSTRAINTS ALL DEFERRED as an alternative to disabling constraints.

    • Master/Detail View:

      • New flag/unflag option for tables via lower-right corner.

    Cross-Platform DDL

    • New menu item “DDL for PostgreSQL” works like “Show DDL,” but generates scripts adapted for PostgreSQL.

      • Includes tables, indexes, constraints, foreign keys, comments.

      • Creates trigger/function pairs as templates for PostgreSQL.

    Grid Usability Enhancements

    • The following grids now support vertical row sizing by dragging:

      • Data Content

      • SQL Query Resultset

      • Query Parameter Input

    Index Management

    • Rebuild Index dialog now includes a logging on/off toggle.

      • Disabling logging speeds up index rebuilds in most cases.

    Spatial Data Improvements

    • Show Geometry (in Data Content grid context menu):

      • Now supports 3D spatial data using 2D projection for display.

    Tablespace Page

    • New tab “SYSAUX Occupants” shows all occupants of the SYSAUX tablespace, sorted by:

      • Used space,

      • Move procedure (if applicable).

    Other Improvements

    • Pipes and Outlines pages have been moved to the DBA group (requires DBA privileges).

    • DBMS Jobs: New context menu item “Convert to Scheduler DDL …” generates code to create DBMS_SCHEDULER jobs (and optionally drop legacy jobs).

      • Supports multi-select for bulk conversion.

    • Tables | Master/Detail Tab:

      • New data grid on the right displays column names and data types for hovered tables.

      • Context menu offers shortcuts for hovered tables: Show DDL, Browse Data Content, Copy SELECT statement.

    • ORDS | Clients Page:

      • Displays granted privileges and roles for each client.

      • Context menu allows granting/revoking roles.

    • ER Diagrammer: Connections now use rectangular connectors instead of diagonal lines for better readability.

    Security and Runtime Updates

      • Installer now includes Wibu CodeMeter Runtime version 8.00a.

      • It is strongly recommended to update the runtime, especially on network license servers.

      • Download: Wibu User Software Downloads

      • Refer to the latest Wibu Security Advisories for details.