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.

See how it works!

Explore possibilities of KeepTool.

Try for free
i,g

Try KeepTool now!

KeepTool’s Oracle database tools have been developed by database application developers for database application developers as well as database administrators and application support. Based on the feedback and requests of our customers, we have been continuously improving our tools for more than 20 years and strive to improve with each new release.
Download KeepTool