Try it for free
Oracle 7.3 - Oracle 21c 20+ years of experience Version (Released: )

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.