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.
Editor syntax highlighting now supports new Oracle 12c Release 2 reserved words.
In-Memory table support.
Added a new “In-Memory” band to the “tables overview” grid for Oracle 12c databases. 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.
Database page shows platform name and open mode from v$database.
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.
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.
Optionally, DB Compare now ignores
Identity options for Oracle 12c identity columns.
Scheduler start date
We added a new menu item “Open in SQL editor” to the SQL page. It allows you to open the current file in separate SQL editor while passing the current database connection.
The data content browser now supports master/detail views like the master/detail view on the data tables/data content view.
Added a “Show DDL” menu item to the access control lists (ACL) view on the database page.
Added a new filter row to the list of tables on the left side of the query builder dialog.
A new data grid on the Database page shows the content of the DATABASE_PARAMETERS view.
Added “rename” context menu items for sequences and table constraints;
Added two context menu items to the “Redo/Flashback | Redo log groups” page that allow you to add a new group or drop an existing group.
Support for PDB operations “save state” and “discard state” on Oracle 12c Release 2 databases. That allows you startup PDBs automatically.
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.