Oracle 7.3 - Oracle 23c 20+ years of experience Version (Released: )
01 Mar 2016
Windows 10 support
WIBU CodeMeter based licensing system
Default skin “DevExpress Style”
New set of material design inspired buttons
A new button in the connect dialog opens a Windows explorer in the folder where connections are stored as XML file.
The direct TCP connection mode now supports object types such as spatial data) XML types and cursor data type
Oracle 12c features
DEFAULT Values On Explicit NULLs clause support.
Improved support for invisible columns.
Support for identity columns.
Hora now shows the host name of the database and the service name (or SID) in the window caption
Improved docking performance of dbms_output and SQL query resultset windows.
Quick navigator buttons next to the overview grids that don’t match any data are now disabled. Remaining buttons show tooltips for first matches.
The schema selector in the footer of the main form now displays the logon schema, SYS, SYSTEM and PUBLIC in blue font. Oracle predefined schemas use italic font and schemas given grants to the logon user use bold font.
Schema page / Oracle Spatial
There are two new context menu items on Schema|Spatial columns page:
DROP spatial index
UPDATE all column data with NULL value helps developers to overcome an ORA-29858 error (ODCINDEXALTER error) after changing the SRS_ID by re-creating spatial index on the emptied column.
A new grid view on the spatial columns page shows all available coordinate systems from MDSYS.CS_SRS.
You can now update spatial column metadata using a modal dialog. Furthermore, the dialog allows you to copy metadata from another column.
A new menu item “Comment Spatial Index Table” creates comments for the MDRT_*$ table that are created by Oracle automatically for spatial index maintenance.
A new menu item “Change SRID (Coordinate System)” allows you to change the SRID metadata, converts spatial data into the new coordinate system and recreates the spatial index.
New menu item “Tables | Copy to clipboard | Table API Package”
creates a packages with member functions for insert/update/delete operations on tables
The “drop constraint” dialog allows you to drop the constraint including the supporting index.
You can now add comments for Materialized Views
Create table dialog
New option “Row Dependencies” to enable row-level dependency tracking. This Option is also included in generated DDL statements.
The “Add stamps” button in the create table dialog now can be configured. Click the “save as default” checkbox to save the current columns as default.
You can now change column order by drag/dropping the row indicator.
The grid contains two invisible pseudo columns ROWID and ORA_ROWSCN. To make them visible, use the column selector in the upper left corner of grid.
Data Content shows headers of primary and unique key column using bold font. Headers of required columns are underlined as before.
Data content banner shows table comment as tooltip hint.
The new button next to “Apply Filter” showing a clock. Allows you to enter a “AS OF TIMESTAMP” expression for flashback query (Oracle 11g or later).
The context menu for spatial data allows you to shows them in an embedded OpenStreetMaps view.
There are two new menu items on the treeview page:
“Filter subtree” builds a SQL condition to select all tree nodes below the current node.
“Filter path to rot” builds a SQL condition to select all tree nodes from the root node up to the current node similar to a bread crumb path.
Method navigator moved to the left side of the editor
Procedure/function list now uses a solid bullet for public methods.
Context menu commands “Selected object | expand SELECT / INSERT / UPDATE / CURSOR-FOR-LOOP” show a checklist dialog that allows you to unselect columns for exclusion from DML generation.
New context menu command “Selected object | Expand SELECT records without details” creates a SELECT statement for the selected table name that returns all records of the master table that do not have any detail record.
New menu command “Format | Format Delphi Stringlist” replaces all ‘#$0D#$0A’ substrings by CRLF characters, eliminates duplicate apostrophes and removes the apostrophes at begin and end of each line. This helps Delphi developers formatting SQL text that has been captured from the debugger at runtime and changes it into pure SQL that can be executed in Hora.
Improved Explain Plan dialog
Both DB object browser and code snippet tool windows are now integral part of the SQL editor window. This allows a tighter integration of SQL code generation. You can drag/drop items into the code window and create SELECT statements, dbms_output clauses and much more. Double-click object names in either code window or object browser to highlight occurrences.
There is also a button to open the SQL query builder.
Navigation buttons for prior and next diff in file compare dialog.
Whereas Hora 11’s session overview displays SQL statements for active sessions only, version 12 can also display SQL for sessions that got recently inactive.
For long running queries, you can see the last ‘long ops’ status message right on the overview screen. In most cases, this eliminates the need to open the long ops sheet. You will love it when monitoring sessions using the auto-refresh option.
The new “Status | Time” column shows how long the session is in the current status
New kill session option “immediate”
The sessions page displays captured bind parameter below the query. See Oracle documentation for details about bind capturing frequency.
A new checkbox “Multi-instance view” allows you to switch between a v$ view based single-instance page and a gv$ view based multi-instance view without changing KeepTool settings as was required in version 11.
New menu item “Reset system parameter”.
New tab sheet “Alert log” shows most recent entries (Oracle 12c)
Reverse DB engineer
You can now select grantees of object privileges.
The tool now remembers the output path for each connection.
DDL generation for Oracle 12c features
Below the tablespaces grid view you can now see a list of related initialization parameters and replaces the db_create_file_dest text box in the top-right corner of KeepTool-11.
New container detail view shows history.
New container properties tab sheet.
New object name exclude list in DB Compare scan options.