KeepTool 14.0.0
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.
- 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 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.
- 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.
- 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.
- Direct TCP/IP mode now supports
Oracle 12 Extended Data Types
BFILEs
- Hora’s Java page now shows methods including arguments and Oracle JVM properties.
- New Hora menu item Tools | Oracle Client | Explore Oracle Home … runs a Windows explorer and opens the Oracle home directory of the Oracle client Hora is currently using.
- In KeepTool 14, the XML Schema page now shows time stamps for XML schema objects.
- New menu items XML Schemas | Register XML Schema and Delete XML Schema.
- New detail sheet “XML Elements” on XML DB page shows XSD structure and mapped SQL names and data types.