KeepTool 7.2.0

19 Mar 2007

• Enhancements to Connect Dialog
  • Passwords can be stored in encrypted form
  • Connections can be displayed grouped by user or server. Connections can also be sorted in reverse chronological order
  • Remarks about connections can be entered and saved using the “Short Description” field
• SQL Page
  • The SQL Repository is now known as the ‘Scratchpad’
  • The File Explorer, which previously allowed navigation among SQL and PL/SQL files only, now displays all files
  • Hora’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.)
  • Elementary lexers for TXT, LOG, as well as .sk, .ksh, .csh
  • A binary file, such as a Word document, can be opened directly from the File Explorer with the related application
  • File Explorer returns to the last displayed directory for each connection
  • Statement detection on the SQL code window
  • New File Explorer navigation buttons on the SQL page
  • Files can be dragged and dropped from Windows Explorer to File Explorer
  • A Print Preview window appears before files are printed
• Schema page | Invalid Objects tab
  • The context menu contains two new entries: “Compile All Invalid” and “Show DDL”
  • Multiple selection is available using the Ctrl key
• PL/SQL Objects page (formerly Packages)”
  • The former Packages page is now known as “PL/SQL Objects”
  • Triggers can now be displayed on the PL/SQL page, in addition to the Tables page
  • The 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
  • Source 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
  • Context-sensitive graying of buttons and menus has been improved
  • The Debugger now automatically provides the Evaluate/Modify function for variables through a tooltipVarious 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:
  • Double-clicking the border between two columns enables Best Fit for the column to the left. This is also true for groups of columns.
  • Best 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.

See how it works!

Explore possibilities of KeepTool.

Try for free