KeepTool 14.0.0

    Published 25. June 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.