Oracle 7.3 - Oracle 23ai 20+ years of experience Version (Released: )

KeepTool 8.0.1

15 Feb 2008

  • Microsoft Windows Vista supported
  • Support for Oracle 11g virtual columns. The table columns grid shows two new check boxes: “virtual” and “hidden.” Use add/change column context dialogs to manage virtual columns
  • Support for Oracle 11g invisible indexes. The appropriate data grid shows the property, and context menu permits modifications.
  • Invisibility (to optimizer) property of indexes is shown in the grid
  • FastReport Designer now allows you to dynamically create new subordinate SQL queries (ODAC dataset integration)
  • Parameter dialog on the SQL page now lets you set the data type for each parameter
  • New “ping” context menu item for database links
  • New “Create | Table from import” item on “Tables | Overview” context menu. Creates column types that match the import source.
  • The list box items showing column names in the “Add foreign key” dialog now can be ordered either by name or logically.
  • New File Search menu item on SQL page’s embedded Windows Explorer window.
  • Tablespace | Fragmentation view has been redesigned. It lists the tablespace’s contiguous chunks of segments and free space in reverse order of the way they are stored in the data file. This means that you will now see segments that prevent downsizing the tablespace at the top of the list.
  • The filter box that dynamically appears below a filtered grid can now recall the last 5 settings using a MRU list
  • The Explain Plan dialog now auto-commits the EXPLAIN PLAN SQL command that is executed when the dialog is shown. Thus the lock on PLAN_TABLE is released.
  • Export from data grid to Excel (data contents and SQL scratchpad) now exports numeric values in numeric instead of string format. Foreign key columns are still exported in “general” format because of technical limitations. Use the export wizard on the underlying dataset to get around this
  • New Refresh button (shortcut F5) next to Commit/Rollback button refreshes the currently active page.
  • DDL creation for external tables has been improved
  • The Query Builder now indicates the type of join (inner, left/right outer) using a solid/framed circle next to the table column. The join type is initialized according to the NOT NULL properties of the joined columns. You can change the join type using the join’s context menu by right-clicking the line that connects the joined tables.
  • Excel export and grid mode for tables with timestamp columns are now supported.
  • Editor code auto completion (Ctrl+Space code) performance has been improved.
  • Increased width of record view controls with context button on data contents page
  • Improved performance in SQL Scratchpad
  • Skinned user interface. The settings dialog allows you to change the visual appearance of the application.
  • New FTP Explorer tab sheet on SQL page allows you to execute scripts right from the server using FTP protocol.
  • Grant dialog for object privileges has been re-designed.
  • PL/SQL Procedures/Call interface page now shows authorization method for procedures and functions (Oracle 9i or later).
  • New tab sheet Statistics Preferences on the Tables page for Oracle 11g. The context allows to change the values
  • Scheduler | Global Attributes can now be changed using context menu (10g or later)
  • Explain Plan dialog shows the new 11g optimizer_use_invisible_indexes session parameter and allows changing.
  • Support for Oracle 11g read-only tables: Tables overview displays it as check box. The properties context dialog allows changing.
  • Read-only data content is shown in gray font
  • DDL generation includes the new property.
  • SGA page shows values of new initialization parameters like sga_target and memory_target.
  • SGA page now adds a new Oracle 11g result cache tab showing result cache statistics, result cache objects and result cache-related initialization parameters.
  • Basic SQL support for inherited object fields
  • Optimized LOB fetching memory usage
  • Query Builder now allows you to save and retrieve a query definition to and from an XML file.
  • Additional parameters are shown for flashback DB (Redo Log page).
  • Support for new 11g connect mode AS SYSASM.
  • Context menu on Schema Privileges page has been improved. It includes now support for granting and revoking privileges.
  • ·Skinned User Interface. You can select between multiple visual appearances by selecting from Extras|Settings – Behavior – Skin name.
  • ·There are different look and feels available such as Office XP blue, black and silver and a couple of seasonal skins like Xmas and Valentine’s day.
  • New options Extras|Settings – Data Contents – Long Numbers as String (default: True). The option defines how different precisions of Oracle’s and Window’s numeric data types are handled. If checked, long Oracle NUMBER columns are displayed as strings without loosing precision. As a result, calculated footer totals are not available. If unchecked, long NUMBERs are mapped to Windows’ double data type with 15 significant digits. Totals such as SUM and AVG are available, but precision may be lost.

See how it works!

Explore possibilities of KeepTool.

i,g