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