Version 12.0.0

  • General
    • 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 types
    • No storage clause is generated for database objects stored in locally managed tablespace with auto segment space management.
    • KeepTool now provides high resolution for large-screen monitors.

  • Oracle 12c features
    • DEFAULT Values On Explicit NULLs clause support.
    • Improved support for invisible columns.
    • Support for identity columns.
  • Hora
    • 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. Oracle’s predefined schemas use italics and schemas given grants to the logon user are shown in bold.
  • 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. The dialog also lets you copy metadata from another column.
    • A new menu item “Comment Spatial Index Table” creates comments for the MDRT_*$ tables 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.
    • Context menu items “Show DDL” and “Manage role privs” added to the Role Hierarchy page
  • Tables page
    • New menu item “Tables | Copy to clipboard | Table API Package”
      creates a package 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
    • Improved support for long numbers on “Create table by file import” menu item.
  • Create Table dialog
    • New option “Row Dependencies” to enable row-level dependency tracking. This Option is also included in generated DDL statements.
      When activated, Oracle puts an SCN on every row and not just on every physical data block.
    • The default columns created by the “Add stamps” button in the Create Table dialog can now be configured. Click the “Save as default” checkbox to save the current columns as the default.
    • You can now change column order by drag/dropping the row indicator.
  • Data Content
    • The grid contains two invisible pseudocolumns 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 columns in bold. Headers of required columns are underlined as before.
    • Data Content banner shows table comment as tooltip hint.
    • A new button next to “Apply Filter” showing a clock. Allows you to enter an “AS OF TIMESTAMP” expression for flashback query (Oracle 11g or later).
    • The context menu for spatial data columns allows you to show 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 root” builds a SQL condition to select all tree nodes from the root node up to the current node similarly to a bread crumb path.
  • PL/SQL page
    • Method navigator moved to the left side of the editor
    • Procedure/function list now uses a solid bullet for public methods.
  • Editor
    • Context menu commands “Selected object | expand SELECT / INSERT / UPDATE / CURSOR-FOR-LOOP” show a checklist dialog that allows you to deselect columns to exclude them 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 records.
    • New menu command “Format | Format Delphi Stringlist” replaces all ‘#$0D#$0A’ substrings with CRLF characters, eliminates duplicate apostrophes and removes the apostrophes at beginning and end of each line. This helps Delphi developers format 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, especially for displaying adaptive plans.
    • Both DB Object Browser and Code Snippet tool windows are now an integral part of the SQL editor window. This allows a tighter integration with 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 the 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 diffs in file compare dialog.
    • Syntax highlighting recognizes Oracle 10g string literals such as
      q'[It’s a string with embedded quotes…]’
  • Sessions page
    • Whereas Hora 11’s session overview displays SQL statements for active sessions only, version 12 can also display SQL for sessions that have only recently become 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 has been in the current status
    • New kill session option: “immediate”
    • The Sessions page displays bind parameters that are captured periodically by Oracle 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 the need to change KeepTool settings as was required in version 11.
  • Database page
    • New menu item “Reset system parameter”.
    • New tab sheet “Alert log” shows most recent entries (Oracle 12c)
  • Materialized View Page
    • Improved column layout and property editor.
  • 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
  • Tablespaces
    • Below the tablespaces grid view you can now see a list of related initialization parameters. This does away with the need for the db_create_file_dest text box in the upper right corner of Hora 11.
  • Container DB
    • New container detail view shows history.
    • New container properties tab sheet.
  • DB Compare
    • New object name exclusion list in DB Compare’s scan options.
    • DDL comparison adds new Oracle 12c features
  • HoraFree
    • … is our ultra-light successor to HoraLight and comes with the most essential features of both the Data Content browser and SQL pages. This tool can be used free of charge.