Version 7

<< Click to Display Table of Contents >>

Navigation:  Getting Started > KeepTool Release Notes >

Version 7

Previous pageReturn to chapter overviewNext page

Version 7.3.0 (2007-10-05)

New installation program

Auto-selection of single statement on SQL execution (Ctrl+E)

Minor tweaks in network license handling eliminated

New versions of ODAC, JAM and DevExpress 3rd-party libraries.

Improved handling for users without OS administration privileges

Manifold SQL generation for triggers on views fixed

Conversation error in tablespace quota dialog fixed

Improved display of PLSQL warnings

Recycle bin objects excluded from several grid and list views

Expired password can now be changed in connect dialog

Sidebar bug button response on first click

Registration form changed

Version 7.2.1 (2007-04-04)

Improved performance of the off-site license usage feature.

Improved performance when working with the floating license and a poor network connection.

Improved performance for displaying of tables with a large number of columns in Data Contents, Data Contents Browser, and SQL Scratchpad.

Optimized display on the SGA & Statistics | SQL area tab.

Version 7.2.0 (2007-03-19)

Enhancements to Connect Dialog

oPasswords can be stored in encrypted form

oConnections can be displayed grouped by user or server. Connections can also be sorted in reverse chronological order

oRemarks about connections can be entered and saved using the “Short Description” field

SQL Page

oThe SQL Repository is now known as the 'Scratchpad'

oThe File Explorer, which previously allowed navigation among SQL and PL/SQL files only, now displays all files

oHora’s integrated editor now displays ASCII files with syntax highlighting and code folding for the most common languages (SQL, PL/SQL, Java, C++, Pascal, HTML, XML, etc.)

oElementary lexers for TXT, LOG, as well as .sk, .ksh, .csh

oA binary file, such as a Word document, can be opened directly from the File Explorer with the related application

oFile Explorer returns to the last displayed directory for each connection

oStatement detection on the SQL code window

oNew File Explorer navigation buttons on the SQL page

oFiles can be dragged and dropped from Windows Explorer to File Explorer

oA Print Preview window appears before files are printed

Schema page | Invalid Objects tab

oThe context menu contains two new entries: “Compile All Invalid” and “Show DDL”

oMultiple selection is available using the Ctrl key

PL/SQL Objects page (formerly Packages)”

oThe former Packages page is now known as “PL/SQL Objects”

oTriggers can now be displayed on the PL/SQL page, in addition to the Tables page

oThe PL/SQL Objects Overview page now contains an additional group, “PL/SQL Debug”

Performance improvements to the DB Object Browser

On the Data Contents page, columns with the NOT NULL attribute are highlighted by underlining the column heading

The context menu on the User Page now makes available the PASSWORD EXPIRE clause of ALTER USER

New display of the Tables Overview in Data Contents Browser and Query Builder through use of high-performance grid components

When SQL Recording is in effect, only successfully executed SQL statements are now saved

Help is now context-sensitive for each page

The Execution Plan now provides more information. A number of new columns have been added (including Options, Optimizer, Position, Cost, etc.)

PL/SQL Debugger

oSource code can now be selected via the menu, providing the Debugger has run for at least one step. After the source code is selected, breakpoints can immediately be set

oContext-sensitive graying of buttons and menus has been improved

oThe Debugger now automatically provides the Evaluate/Modify function for variables through a tooltipVarious bugs corrected

Various bugs corrected

In ER Diagrammer, the hints for connections between tables have been moved further from the connecting lines to facilitate working with the lines

Line breaks and spaces in SQL Editor are ignored when a selected SQL statement is being executed.

New Import/Export Wizard dialogs that allow saving and loading of user-specific profiles via the Specifications button.

When printing, paper size defaults to either A4 or Letter depending on regional settings.

The "Optimizer Mode" combo box under Extras | Settings | Session has been redesigned. The FIRST_ROWS and ALL_ROWS options are no longer available. The field can be edited so that combinations of options are possible.

A new "PL/SQL Warnings" check box is available under Extras | Settings | Session. This enables PL/SQL warnings to be enabled or disabled for 10g databases. - Hora no longer shows package names in red on the Overview page when only warnings have been generated. They will not be shown in red unless there are actual errors.

Hora automatically requires a new password when a user's password has expired.

The Connect dialog has been made larger in size.

Hora issues a warning when the oci.dll file predates the database.

If no file has been selected on the SQL Page's File Explorer, the editor becomes read-only and has a gray background.

Improvements to the "Best Fit Columns" function:

oDouble-clicking the border between two columns enables Best Fit for the column to the left. This is also true for groups of columns.

oBest Fit Columns" can be automatically put into effect for a certain number of columns or groups, using a new option in Extras | Settings | Behavior.

Using the check box in the filter panel below the data grid, you can temporarily disable the filter.

The Tables and PL/SQL page now offer an "Include Synonyms" check box in the upper right corner. The Synonyms tab has been removed from the Tables page.

Hidden files (those whose name begins with a period) can optionally be made visible or hidden in SQL Scratchpad's File Explorer. The check box to set this option can be found under Extras > Settings > SQL Page > Hide period-prefixed files.

The SQL Page now offers the ability to execute a single SQL statement with Ctrl + E when the cursor is placed on it.

Alphabetic sorting in SQL Scratchpad has been corrected.

Improved performance when switching between tasks.

Version 7.1.0 (2006-10-06)

Hora now shows the Oracle version and SID in the main form's title bar

Jobs can now be shown for the current schema or optionally for all schemas

User/Roles: A new detail view shows the users and roles that have been granted object privileges for the current user

Overview Tables: New Errors column in the Flags group. This is always NULL, except for Views. Views with errors are also shown in red

Several bug fixes

Version 7.0.3 (2006-09-16)

Improvements to the Sessions page:

oA new group, "Waiting," has been added to the Overview, with columns "Waiting Since" and "Seconds"

oAn additional column, "Transaction and Blocking," has been added to the Status group

oAnother additional group, "Wait Object and Row," has been added

oInformation identifying the client application is displayed on the right, in a non-scrolling section

oOnly the session causing a lock will now be shown graphically. A session that holds a lock will only be listed in red when it is blocking another session. A blocked session will no longer be shown in red. Note: To use this feature, available starting with Version, the HORA_USER role must be redefined

The Scheduler icon has been redesigned in a different color to differentiate it from the Jobs icon

Grant Object Privileges dialog now recalls last selected privileges

Improved accessibility to tables in other schemas: Ctrl+Space enables table search without the need to specify owner in Current Schema

SQL Query Result Set window does not automatically close when leaving the SQL page

Corrected problem in Find/Replace in Editor when regular expressions are specified

New Data Contents Browser context menu item: the Editor opens a modal dialog for CLOB columns

New Enable/Disable context menu item for the Scheduler

Maximizing and restoring of the DBMS_Output window now possible after closing the window

PL/SQL Debugger: context menu allows clearing the DBMS_Output window

ER Diagrammer, DCB and Query Builder show all owners if user has the SELECT ANY TABLE privilege

ER Diagrammer now clarifies relationships through tool tips

Dependent and independent tables are visually differentiated in ER-Diagrammer. Non-identifying relationships are now shown as broken lines

Several bug fixes

Version 7.0.2 (2006-02-24)

The Tables context menu allows monitoring for all indexes to be set on or off

The Indexes context menu allows monitoring to be set on or off for individual indexes

Information from V$OBJECT_USAGE is now displayed for indexes

Improved performance when moving from Overview Tables to the Data Contents Browse

Enhanced display in SQL Editor's Outline window

Enhanced appearance of SQL Editor's Code Folding feature

Improvements to direct Excel export (Excel file now shows grouping by columns, when in effect)

Improvements in navigation through Database Roles

Improvements in Data Contents (new Record View, new Text View, enhancements to the column headings in Grid View, display of BLOB fields using Windows applications)

Version 7.0.1 (2006-01-30)

A new and easier-to-use interface in all Version 7 products

A powerful new data grid component, with much better performance when managing query results available through the optional in-memory mode on the client, for



oGrouping, including multiple levels

oCalculation of sum, average, min, max, count

oFor details, see

New SQL Editor with

oCollapsible code

oText folding

Enhanced capabilities for applying color scheme

oFor details, see

Additional Oracle 10g support: Scheduler, XML

Integration of the latest version of the Fast Reports 3 report generator

Explain Plan tree view now presents information about each step in column form

Integration of new WYSIWYG printing component

Enhanced performance on Tables page

Improved functionality in PL/SQL Debugger

ER Diagrammer now based on new diagramming component (FlowChart)

oFor details, see

Version 7.0.0 (2005-11-10)

Hora 7 pre-release becomes available, with full release of KeepTool 7 to follow.