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
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.)
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 18.104.22.168, 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 www.keeptool.com/newsletters/060110/Grid.html
•New SQL Editor with
•Enhanced capabilities for applying color scheme
oFor details, see www.keeptool.com/newsletters/060110/Colors.html
•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 www.keeptool.com/newsletters/060110/Diagrammer.html
Version 7.0.0 (2005-11-10)
•Hora 7 pre-release becomes available, with full release of KeepTool 7 to follow.