On the AWR SQL history page, Hora now displays the SQL execution plan in the code window right below the SQL text.
The DB object browser on the right of the SQL editor window now allows incremental search. Just make sure the tree view is focused and start typing. Additionally, a new search box below the browser allows you to filter items by a search string.
The popup menu that appears when you drag a PL/SQL procedure or function name from the DB object browser into the code window, now contains three "PL/SQL call" items. Whereas the hitherto item is predicated "single-line", one new "multi-line" item generates each argument on its own line including preceding "=>" argument names. Another new "select from dual" item generates a function call from a SQL statement rather than a PL/SQL block.
A new menu item "Selected object" | "Rewrite Oracle proprietary joins to ANSI SQL complient joins ...". has been added to both embedded editor windows as well as the standalone SQL editor. The dialog converts all Oracle proprietary joins to ANSI SQL compliant joins and shows a preview of the result. Compound queries containing more than one SELECT such as nested subselects, WITH, or UNION are not yet supported. Convert parts separately.
For identity columns, the Tables | columns view now shows a new identity generation type column (ALWAYS, BY DEFAULT) that replaces the identity checkbox.
We added a "New resultset window" button (and a menu item as well) to the SQL page. It creates a new empty SQL result set window that will be used incipiently by the next SQL execution. The hitherto used result set window keeps active including its data content until you close it manually. As a result, you can now keep multiple SQL result sets alive at the same time. The result set of subsequent SQL executions is always displayed in the most recently created result set window.
We added a new button "flush data" to Hora's PL/SQL profiler dialog. It allows you to update statistics and refresh grid data without stopping the profiling utility.
There are two new options in DBDoc that allow you to exclude either constraint or index definitions from the database documentation. We added two new buttons to the right of the checkboxes that allow you to select or unselect all checkbox options at once.
DbDoc language option now defaults to your Windows language setting.
There are also some minor improvement on the layout of the DbDoc generated document, such as required columns are marked "X" instead of "NOT NULL". Byte semantics is excluded from character column definition if it meets the session default.
ER Diagrammer has been furnished up with a toolbar. Menu items got icons matching the toolbar buttons.
ER Diagrammer: Added a new "DbDoc for Diagram .." submenu item to the "Diagram" main menu item. It opens DbDoc for the subset of tables defined by the current ER diagram.
ER Diagrammer's auto-layout is now a separate menu item. "Modify diagram" does not trigger the auto-layout any more.
Version 14.1.2 (2019-10-24)
New context menu item 'Cancel SQL' on sessions overview page for Oracle 18c and later.
New Oracle 19c reserved words added to syntax highlighting.
If you drag-drop a procedure or function name from the DB object browser into the code editor window, a pop-up menu item allows you to insert an anonymous PL/SQL block that includes parameter declaration, procedure or function call, and print-out of the results. This call interface can be used for testing your PL/SQL code. Now we added another similar menu item that adds the procedure call including arguments only without the overhead of an anonymous PL/SQL block. This can be used to add a procedure or function call to your existing PL/SQL implementation.
DB Compare, Reverse DB and Hora's "Show DDL" menu item now support the special syntax of Oracle CTX indexes.
In the connect dialog, the logic of the context menu item to remove a connection from the grid view is now also available as a button. You can find it below the data grid.
New "Refresh" button on DB object browser in code editor windows.
New "Show DDL" menu item on tables | triggers grid context menu.
Hora's Show DDL command and both Reverse DB and DB Compare ignore DBMS_JOB$_<nn> jobs that have been generated implicitly by Oracle for classic non-scheduler jobs.
The setup installs the latest Wibu CodeMeter runtime version 6.90b. It is recommended to update the CodeMeter runtime on your network license server as well. Therefore download the runtime setup from https://www.wibu.com/de/support/anwendersoftware/anwendersoftware.html . Minimum OS requirements are either Windows 7 or Windows Server 2008 R2.
Version 14.1.1 (2019-08-14)
The data content menu item/button "change column order" is now also available for the SQL query result set on the SQL page.
Two new sub-menu items added to the "Selected object" context menu of the SQL page: "Expand View name to SQL definition" replaces a selected view name by the SQL text of the view definition. The same menu item has been added to the menu that pops up when you drag-drop a view item from the DB object browser into the SQL editor. This feature makes it easy, to analyze a view definition."Expand View name to SQL definition" replaces a selected view name by the SQL text of the view definition. "Add dbms_output.put_line(..)" adds the mentioned call to the next source code line to print out the selected variable.
The modal dialog that displays Oracle error messages has got a new "copy message" button that allows you to copy the Oracle error message to the Windows clipboard.
Deprecated PLSQL_DEBUG parameter on settings page, compile debug menu item and statusbar button have been replaced by PLSQL_OPTIMIZE_LEVEL.
Improved PDF/A output of integrated FastReport component
The number of skins provided be default has been reduced. We recommend using scalable vector skins such as "The Bezier". Customize the %PROGRAMDATA%\KeepTool14\ExcludedSkins.txt file to show more skins. Mail your favorite skin names to our customer support as a suggestion to keep it enabled by default.
Version 14.1.0 (2019-07-15)
New visual appearance of the installer.
Oracle 19c database support added.
New column "cursor type" on sessions | open cursors page.
Added a combobox on top of Database | Alert log page to change the limit of time stamp range. Default keeps the last hour, you can enlarge the time span up to the whole log file. Added new grid columns: Module, Process ID and Container.
The new find panel on the alert log page allows you to highlight search text occurrences anywhere in the data grid.
ER Diagrammer now comes up without the two default pages "Entire diagram" and "Remaining tables", because that produced a cluttered view for big schemas having a very large number of tables and foreign key relations. Rather you are prompted now to start with creating your first own diagram by selecting a reasonable subset of tables. The logic to identify remaining tables that are not covered by any diagram page is now available as a button in the diagram definition dialog.
New vector skin Office2019Colorful
Version 14.0.7 (2019-05-06)
Reverse DB now allows you to export data as MERGE script as an alternative to the INSERT script. Use the radio group "statement type" to change. Furthermore, you can restrict the amount of data by entering a WHERE condition that can be applied to each selected table. For example, you can export records only that have been added or updated recently by entering a minimum value for the ORA_ROWSCN pseudo column that is available for each table. Reverse DB generates a sample WHERE condition based on ORA_ROWSCN and the system's current SCN. Decrease the value to export more records. You can use the TIMESTAMP_TO_SCN( ) function to compute the SCN for a given timestamp within the recent past. Please remember, the ORA_ROWSCN pseudo column can be included in Hora's data content views after both changing the "select ORA_ROWSCN" setting to either "automatic" or "always", and unhiding the invisble ORA_ROWSCN column in the data content view. Create the table with ROWDEPENDENCIES clause for having ORA_ROWSCN associated on row level rather than block level.
Sessions | Open cursors page shows additional columns "last SQL active time" and "cursor type" (Oracle 11g and later).
Version 14.0.6 (2019-04-15)
The session overview page now shows both current and previous SQL, if both are available from the data dictionary.
The Sessions | locks page now shows below the locks grid both name and type of the locked object. In case the locked object is of TABLE type, the page displayse the ROWID and a button that allows you to copy to the clipboard a SELECT statement to query the locked row. Another button opens the SELECT statement in the SQL query resultset window, showing instantly the locked row data.
The "Find PLSQL" dialog is now a non-modal tool window that still stays on top, but allows navigating the underlying code window. It also shows a preview of the find results's object source within the dialog.
The optional login script now allows you to use a :PARAMETER to enter a password or other sensitive information to avoid storing it within the script. If the parameter name either contains the substring PASSWORD or starts with the underscore character "_", the input dialog displays a special character in place of any entered text. Use this for entering passwords, etc.
A new button in the expandable section of the login dialog allows you to open the login script in the SQL editor.
You can use shortcuts CTRL + and CTRL - from the decimal keyboard to temporarily increase editor font size, for example within a presentation.
There is a change of character encodings available in the editor component. You can now choose between any of: ANSI (compatible with Oracle SQL*Plus) UTF8 (without BOM, compatible with Oracle SQL*Plus) UTF8 BOM (with BOM, default encoding for MS-Windows) The default encoding for new files is UTF8 and can be changed in the settings dialog.
DbCompare has got a new 'abstract' comparable object type "Spatial Metadata" (USER_SDO_GEOM_METADATA) that allows you to compare spatial metadata such as bounding rectangle definition and SRID for spatial columns.
When using the SQL query builder from the SQL editor, you now will be asked whether to append the SQL at end of file or insert at cursor position. The choice can be changed later on at settings | SQL page | Query builder append at EOF.
Added DBMS_LOCK_ALLOCATED dictionary view and AWR related views DBA_HIST_SYS_TIME_MODEL, dba_hist_database_instance, dba_hist_sqlstat, dba_hist_sqltext, DBA_HIST_BASELINE, V$OSSTAT, (and optionally uncomment DBMS_WORKLOAD_REPOSITORY package) to HORA_USER role.
Wibu CodeMeter runtime version 6.81 is included. Please update CodeMeter runtime on your license server to version 6.81 from https://www.wibu.com/de/support/anwendersoftware/anwendersoftware.html as well.
Version 14.0.5 (2019-02-11)
Improved trial license management.
Wibu CodeMeter runtime version 6.80 is included. Please update CodeMeter runtime on your license server to version 6.80 from https://www.wibu.com/de/support/anwendersoftware/anwendersoftware.html as well.
Enhanced right-to-left text support of several UI controls.
Improved performance of DB object browser on SQL scratchpad for database schemas with tens of thousands of objects.
Improved performance on Java page.
The sessions | locks page now includes additional information for custom locks created by dbms_lock calls.
Removed "SQL" option from data export wizard. Use "Create INSERT script" context menu item instead.
Version 14.0.4 (2018-12-17)
Oracle 18 support
New context menu item for tables|columns: "Drop unused columns ...".
The tables|add column dialog now allows you to add invisble columns by marking a checkbox similar to the properties/alter dialog.
The PLSQL window now highlights PLSQL errors (red) PLSQL warnings (yellow) Unused procedures and functions in package body (gray) based on ALL_IDENTIFIERS evaluation. Both the gutter bullet and the color map next to the scrollbar now use the same colors as the error/warning list below the code window. You can disable highlighting of warnings or unused procedures in the settings/behavior dialog.
The SQLEditor now supports UTF8 file format without BOM. To be sure, you can now select the encoding from a combo box in the FileOpen dialog. If you choose the "default" setting, the file content will be analyzed for an educated guess of the encoding.
The data content browser allows you to save your workset as XML file for later reopening the same collection of tables. Now the schema name will be excluded from saving in case you are working on the current schema. That allows you to open the workset on another copy of the schema with a different schema name.
The clear schema procedure now temporarily disables the recycle bin for better performance, if you are granted the HORA_USER or SELECT_CATALOG role.
The integrated FastReport engine has been upgraded to the most recent version 6 that allows more complex reports and additional report objects such as maps and barcodes.
When closed in normal state (not maximized), Hora retains screen position and main window size for next startup. This can be disabled by unchecking the checkbox in settings / startup window / Remember main window position and size.
The SQL editor remembers the path of the integrated file explorer and restores it on next startup.
Version 14.0.3 (2018-11-06)
The database|NLS parameters data grid now has got both a new context menu item and speed button "Show ALTER SYSTEM script ...'. It allows you to create a script that sets the current instance settings by ALTER SYSTEM statements. That makes it easy to transfer this settings to another machine.
Most data grids including data content and SQL query result grids got both a new button and menu item "copy to clipboard". It copies the grid data into the Windows clipboard as a TAB delimited list. If the data set has less than 1000 records, the copy command places an additional HTML formatted copy into the clipboard. That allows you to either paste the data into a text editor as unformatted text or paste it as fully formatted table into applications such as MS Word or MS Outlook. There is no need any more to email screen shots of your data grids to your clients, send the data instead.
Added a new tab "NLS" to the "settings" dialog. It allows you to override national language support settings for use within KeepTool for all database connections. You can keep some entries blank to use default settings (as before) defined by Oracle registry and environment variables. Two buttons allow you to initialize using default settings from your Oracle client as a start for further changes, and to clear all entries.
Version 14.0.2 (2018-09-20)
In data grids, the scrollbar thumb is initially hidden now for a clearer view. It appears when the user hovers the mouse pointer over the grid or scrolls through its content. Hovering the mouse pointer over the scrollbar thumb or its movement path transforms the thumb to a traditional scrollbar. Moving the mouse pointer away from the scrollbar reduces it back to the thumb. The thumb disappears if the mouse pointer is stationary or the control is not scrolled for some time. You can disable the new feature in settings | Behavior | Grid Scrollbars Always Visible. For remote desktop connections, the feature is always disabled.
Improved data grid to excel export performance.
Changes to Excel export options: The existing checkbox "Data only Excel export keeps formatting" has been renamed to "Excel export retain grouping and calculated totals". When checked, in-memory grid features such as column grouping and group/overall totals are retained as Excel formulas. When unchecked, the export retains more visual attributes such as background colors. A new checkbox "Excel export all cells formatted as text" allows you to export data as text that are not supported by Excel such as dates before 01-01-0100.
New skin “The Bezier” uses scalable vector graphics based on SVG images. It is the new default, when Hora is installed on a new machine.
Wibu CodeMeter runtime version 6.70 is included. It is recommended to update your network license server as well.
·Settings dialog: AutoCommit option has been moved to the “Session” page. A new checkbox “Hide Trailing Time Zeros” on “Data Contents” page has been added. When checked, trailing zero seconds and zero times (00:00:00) are not displayed in data content and not exported to Excel.
Manage Role privileges dialog: Data grids “available” and “grantable” privileges have been swapped. On the left side, you see now the granted privileges. “Contains” operator has been enabled for filter operator similar to other data grids.
The 5th button on the main toolbar allows you to gradually fade the green color of most recently changed objects. Its icon has been changed from a green checkmark to a green screen-painting-brush.
The users page provides two context menu items to create a expdp/impdp template for Oracle datapump export/import. In this version, each datapump parameter is generated on its own continuation line.
A new Reverse DB checkbox "Wrapped PL/SQL" defaults to "True" and lets you decide weather to include wrapped PL/SQL code or skip those objects from reverse engineering.
The "arrange columns" menu item (data content) has been improved: Performance enhancements for tables having a very large number of columns. The dialog shows more column names at the same time using a multi-column layout. A new search box allows you to find columns names by entering a search string. All column names that do not match the search string are disabled and grayed, leaving the columns matching the search string in regular font.
The SQL Editor now remembers the width of the files-in-folder list on the left including the "hidden" status of the files panel.
DbDoc got 4 new checkboxes to optionally exclude technical content from the report, also available as command line options for batch reporting.
DbDoc report appearance has been enhanced using internal css styles.
System environment information dialog now shows installed anti virus products.
Version 14.0.1 (2018-07-25)
On Data Browser detail tab change, Hora preserves now splitter positions for each detail table separately.
Performance of data fetching in the Direct mode is improved.
Support for TIMESTAMP WITH TIMEZONE in Direct mode is improved.
When Hora has been idle for at least 15 Minutes, it executes now a dummy SQL statement to overcome any SQL*Net connection timeouts.
Performance enhancement for “Create table by file import” dialog when importing ASCII data. Configurable decimal and thousands separators.
Both data content and SQL result set grids are now able to pin rows to the top or bottom of the grid. First, click the check box to enable in memory grid mode. Now you can see a pushpin icon hot-tracking the current row. Right-click to open a context menu and pin it to either top or bottom of the grid.
Version 14.0.0 (2018-06-25)
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 databases. 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.
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.
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.