Published 10. April 2025
INSERT script lines containing spatial data are now automatically split into multiple lines, each shorter than 2000 characters, ensuring full SQL*Plus compatibility.
Properties View:
Previously, the last tab on the CDB page only showed properties of the currently selected Oracle container database.
You can now view the properties of all CDBs side by side, making it much easier to compare PDB settings.
Property values that differ from those of the root container are highlighted for clarity.
Tablespace Usage:
Previously, a checkbox indicated whether a tablespace was used in a given CDB.
This has been replaced with a numeric value showing the total MB used by the CDB, offering more precise insight.
Since version 16.1.0, the tables overview page included a menu item for creating DDL for PostgreSQL DB.
In 16.2.2, a similar menu item has been added for Microsoft SQL Server.
Accessible via the context menu in both Data Content and SQL Query Resultset grids, the dialog now offers:
Persistent dialog size (remembers last used size).
Improved formatting:
Required columns in blue,
Primary and unique key columns in bold,
Consistent with other data grid views.
Data type icons shown next to each column.
Tooltips displaying data type and column comments (when Settings → Data Content → Show active tooltips in grid view is enabled).
The “Copy to clipboard” menu item on the tables context menu has been renamed to “Generate code” for clarity.
In the column selection dialog (for SELECT, INSERT, or MERGE statements), data type icons are now displayed alongside column names.
In version 16.1.0, a data grid was introduced in the master/detail view showing column names and data types of the hovered table.
In 16.2.2, this grid now also displays column comments.
Tip: Resize the grid area to give more space to comments for improved readability.
The Create INSERT/UPDATE/MERGE script dialogs now allow definition of replacement expressions for specific columns.
Example: Replace a primary key column with SEQUENCE_NAME.NEXTVAL instead of exporting existing values.
Features include:
Assigning one or more column → expression pairs.
A dropdown with suggested expressions (e.g., sequences, timestamps).
The flexibility to enter custom expressions manually.
Data type icons now use a semi-bold font, giving the UI a lighter appearance.
The “Show DDL” command for users now prompts for options on what to include/exclude, and remembers your choices for the next usage.
In the table column selection dialog (for creating INSERT/UPDATE/MERGE SQL):
Additional quick-select buttons have been added.
Available options now include:
✅ Check all columns
✅ Check required columns
✅ Check primary/unique key columns
✅ Check indexed columns
❌ Uncheck all columns
❌ Uncheck columns with default values
❌ Uncheck columns calculated by triggers
Reverse DB: New checkbox “Always prefix object names with schema name.”
When unchecked (default), schema prefixes are only applied for objects outside the current schema.
Hora Settings (Behavior page): New checkbox “Always include schema prefix in Show DDL command.”
Ensures consistent script generation, particularly useful when running scripts as SYS.
Faster rendering of vector-based skins, especially noticeable with the WXI skin.
The setup now installs Wibu CodeMeter Runtime version 8.30a.
Strongly recommended: Update the CodeMeter runtime, especially on network license servers.
Download: Wibu User Software Downloads
See also: Wibu Security Advisories.