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.

i,g

Try KeepTool now!

KeepTool’s Oracle database tools have been developed by database application developers for database application developers as well as database administrators and application support. Based on the feedback and requests of our customers, we have been continuously improving our tools for more than 20 years and strive to improve with each new release.
Download KeepTool