Published 23. April 2024
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.
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.
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.
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.
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.
The “Lock Wait Graph” tab has been renamed to “Blocking Sessions.”
Now displays a multi-column tree view with more information about blocked sessions.
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.
The tree view now shows the foreign key name for detail tables with multiple references to the same master table.
“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.
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.
The following grids now support vertical row sizing by dragging:
Data Content
SQL Query Resultset
Query Parameter Input
Rebuild Index dialog now includes a logging on/off toggle.
Disabling logging speeds up index rebuilds in most cases.
Show Geometry (in Data Content grid context menu):
Now supports 3D spatial data using 2D projection for display.
New tab “SYSAUX Occupants” shows all occupants of the SYSAUX tablespace, sorted by:
Used space,
Move procedure (if applicable).
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.
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.