Oracle 7.3 - Oracle 23c 20+ years of experience Version (Released: )
25 Jun 2018
In KeepTool 14, internal file names of the executables have been consolidated with the application names as seen in the appropriate Window captions.
The new data-aware Excel export is optimized for subsequent analysis of grid data within Microsoft Excel. The following data shaping options that are applied within the grid control (when using the “in-memory mode”) are retained in the output XLS and XLSX documents.
Data grouping – with the capability to collapse/expand groups within a worksheet
Totals and group summaries – with the capability to modify/change formulas
Merged Column Grouping (when using the “in-memory mode”):
This release introduces a new data grouping mode that enables you merge grouping columns, allowing for a more compact row list. Pressing and holding the Ctrl key while dropping a column header adjacent to another one located in the Group By box merges the two columns.
In-Memory table support. Added a new “In-Memory” band to the “tables overview” grid for Oracle 12c database. A new context menu item “In-Memory” allows you to enable in-memory table mode and change attributes. Both Hora’s show DDL menu item and Reverse DB engine output include appropriate code to enable in-memory table mode.
New page Additional | Editions.
Each filter row now allows you to select an operator such as “=” from a drop-down menu, depending on the data type of the column. This feature had been introduced earlier for data content and is now propagated to all grids having a filter row.
Database page now shows server platform name, database role and open mode from v$database.
More options for SELECT and CURSOR FOR LOOP SQL generation including ORDER BY option and optional BEGIN-END block encapsulation.
Added a search box to the “select columns” dialog. Now you can search for column names when creating a select, insert or update statement. Column items that do not fit the search mask are temporarily disabled.
Reverse DB now allows you to export table data as SQL scripts. In a subfolder you find an insert script for each selected table along with two scripts to disable and enable constraints and triggers before/after the data import.
DB compare now re-orders the columns of the table on the right in accordance to the order of the column names of the table on the left. As a result, different column order between tables is not displayed as a change any more.
Up to Oracle 12c release 1, the dialogs for adding a (virtual) column, check constraint and functional index now make sure the REGEXP_REPLACE function is not used although it is not deterministic (See Doc ID 20804063.8). Starting with Oracle 12c release 2, Oracle performs this check itself.
The connect dialog shows NLS_LANG parameter of the currently used Oracle Home in the expandable section of the dialog.
KeepTool 14 comes with a new set of program icons and splash screens.
The “File” and “Database” main menu items of Hora and SqlEditor have been consolidated.
For Oracle 12c databases, the list of database parameters shows a new column that indicates if the parameter is changeable for a PDB.
New “Compile Java” menu item and button.
KeepTool 14 comes with enhancements for high DPI monitors.
PL/SQL call interface generator now creates extra code for Boolean parameters that allows you to use substitute ‘Y’ and ‘N’ string values.
Filter by selection commands in both tables|data content and data content browser now add a N’ prefix to string literals when filtering NVARCHAR2 or NCHAR columns. That allows you to filter by Unicode literals.
Schema page now shows erroneous PL/SQL source line in conjunction with error message.