06 Dec 2021
- KeepTool 15.0.0 now supports Oracle 21c Database as well as Microsoft Windows 11.
- Database object flagging
- Both on Hora‘s tables/views and PL/SQL overview grids as well as on the data content browser, query builder,sequences and PL/SQL types overview grids you can now flag individual database objects. A combo box in the new “Flag” column allows you to select a symbol such as a colored bullet, a warning mark, etc. Use the built-in filter technologies to filter objects by symbol.
- The data object browser in the right of the editor window displays the symbols as well, but you cannot change them there. Press F5 to refresh.
- Hora‘s master/detail view displays the symbols within the shape that represents the table.
- ER diagrammer displays the symbols in both listboxes for selected and remaining tables.
Two new buttons for each listbox allow you to select flagged or unflagged tables.
- The connect dialog now allows you to star connections as favorite.
The list of recent connections shows the ‘favorite’ property as first column.
Use build-in filter technologies to filter favorite connections.
- The embedded SQL editor component allows you to drag and drop code snippets from a tree view into the code window. Up to KeepTool 14, the data source was a text file CodeSnip.txt located in
Now we moved to XML in order to support multi-line snippets. The data source has been relocated to
%appdata%\KeepTool15\Templates\CodeSnip.xml and can be changed using the settings dialog.
You can now add, change and remove Code snippets interactively. Press the “save” button to persist changes. Use the “refresh” button to reload changes made in another instance of Hora.
- Hora‘s data content browser now shows a tooltip hint for the caption of the detail table view.
The hint displays the table comment of the detail table, similar to the existing behavior of the master table.
- The header of Hora‘s Java overview page now shows the concatenated package path for the currently displayed Java object.
- Hora‘s data content browser page allows you to display a detail view of a page that has no foreign key relation to the master table.
Now you can add multiple free detail tables. After one detail table has been added, there appears a new tab for adding the next detail.
If you quit the “select detail table” dialog using the Cancel button, the tab is deleted, besides it is the last tab.
- Hora‘s data content grids and record views now display a ‘key’ icon in each key column header.
- Hora‘s Tables | Master/Detail diagram now displays the table’s comment as a tooltip.
- For Oracle 11g an later, Hora‘s session | open cursors page
- Displays an additional column “User”
- Shows records in gray if
- The cursor type column does not contain “OPEN”, or
- The optimizer column is null, or
- The new user name column does not match either the “User” or “Schema” column displayed in the sessions overview data grid.
- There is an additional tab “Network client” on the sessions page.
It shows network adapters that have been loaded. That may indicate that encrypted network communication (SQLNET.ENCRYPTION) has been enabled as well as active data integrity options (SQLNET.CRYPTO_CHECKSUM). Furthermore, it lists more client information such a OCI client version and client character set.
The overview grid displays two new columns “Encryption” and “Checksum” in the “Client machine” group that summarizes the most relevant information regarding encryption and checksumming.
- There is a new “Direct TCP/IP” options tab on the settings dialog. The existing combobox to select the “IP version” has been moved there.
Two new combo boxes “Encryption” and “Crypto checksum” implement a behavior similar to the sqlnet.ora levels ACCEPTED and REQUIRED for both SQLNET.ENCRYPTION_CLIENT and SQLNET.CRYPTO_CHECKSUM_CLIENT entries.
Default value for both is “Accepted”. Change to “Required” mode to enforce security. “Requested” mode is not yet implemented.
- Hora‘s schema dependencies diagram has been moved from the database page to users page.
Double-click a schema to navigate to the appropriate user in the overview grid.
- Hora’s Container database overview page now shows
- NLS character set and NLS language
- Another detail grid that displays recent PDB plugin violations.
- Hora‘s create DB link dialog now shows a combobox for the referenced service name. In case of a SQL*Net connection, it lists the TNS aliases from the client. Make sure the selected alias has been configured on the server as well. Maybe you want to share one tnsnames.ora include file with all machines.
- For PL/SQL object types, Hora now shows a new context menu item “Generate XML schema”. It creates a XSD file using Oracle’s dbms_xmlschema package and shows it in a popup window.
- Several improvements for XML schemas and XML_TYPE tables and columns
- New options added to the create “XML schema” dialog
- All XML DB pages now are filtered by the current schema, similar to other Hora pages.
- XML elements page shows the element’s XSD part as a detail information to the tree view.
- New XML columns sheet.
- Added dependecies tab.
- Improved DDL generation for XML_TYPE tables and columns
- Reverse DB generates code to register XML schemas.
- DB Compare considers XML schemas.
- Hora‘s refresh group data grid on the Material Views page
- Shows an additional column that counts the number of refresh children in the group.
That allows you to identify non-trivial refresh groups on a single glance.
- Both Show DDL and Destroy menu items are enabled for multi-selection now.
- There is a new context menu item ‘change’ to modify a refresh group.
- For non-trivial refresh groups, the ‘DDL’ creates an empty refresh group and then adds material views one by one.
That makes your manual changes easier to perform.
- MAKE() is followed by a CHANGE() to make sure both NEXT_DATE and INTERVAL parameters are set.
- SQL query builder now uses bold font for primary key columns.
- ER Diagrammer has got a new context menu item for entity/table shapes.
“Copy table name” allows you to copy the table name to the clipboard.
- DB Compare now includes Oracle Contexts, as far as the user has select privileges on DBA_CONTEXTS.
There are no ALL_ and USER_ views for contexts.
- DB Compare logic for creating schema consolidation script has been improved:
- The DB object treeview now has got a root item “Schema”. If this “Schema” item is been focused, the schema consolidation script processes all changed objects.
Unchecked objects are excluded.
- If a DB object type node such as “Tables” is focused, the schema consolidation script processes all changed objects of the appropriate object type..
Unchecked objects are excluded.
- If a DB object node such as “EMPLOYEES” is focused, the schema consolidation script considers the focused DB object only.
- The SQL Editor now shows additional elements for the bread crumb bar that shows the file path:
- Buttons to navigate the history
- Combobox button
- Refresh button
- Explorer-like search box
- Form painting on resize has been improved resulting in a smoother experience.
- The setup 184.108.40.206 installs Wibu CodeMeter runtime version 7.30a. KeepTool 220.127.116.11 comes with the most recent CodeMeter version 7.40
It is strictly recommended to update the CodeMeter runtime on your network license server as well.
Therefore, download the runtime setup from https://www.wibu.com/support/user/user-software.html .
- A new option “Settings | Data Content | Single-line INSERT statements in script” has been added in version 18.104.22.168.
It allows you to put each INSERT statement within an INSERT script into one single line.
When unchecked (default), both the VALUES clause and LOB handling appear on separate lines below the INSERT INTO line.
In each case, Hora keeps inserting a line break after a hyphen at EOL to avoid SQL*Plus from interpreting it as continuation character.