KeepTool Blog - Current

SQL Query: No auto-commit after execution. After execution, the number of lines affected is displayed and the commit must be confirmed-otherwise a rollback will be executed. SqlQuery with live result set still uses auto-commit SQL Query: Position of syntax error is displayed Editor: The GotoLine dialog now works with a combo box containing the last-used […]

Reverse/DDL: Generation of tablespace parameters and storage parameters can be deactivated Drop Column is offered now with ALTER TABLE (Oracle 8i only) New feature: On Delete Set Null HEdit: All buttons are now context-dependent PL/SQL Debugger out now! Oracle Server Version 7.3.4 or higher is needed for the Debugger

Tables|Contents: You can enter decimal places in columns of type NUMBER (without precision/scale) HEdit: At execution time the character / will be interpreted as end-of-statement only if it is placed in the first column

After selection of all Tables/Views the ReverseDDL selects only the appropriate comments The ColumnHeaderClick event (which changes the sort order) will not be triggered after moving columns EXECUTE SELECTION on the SQL page Recall buffer for the most recently executed statements on the SQL page

New feature: By using the context menu (Properties/Alter/Rename), all constraints can be renamed and modified. Now it is possible to change a foreign key to cascading and to change the search condition for a constraint. In case of error, the existing constraint will be restored. Before renaming a primary key, dependent foreign keys must not […]

MDI technique Direct access to Oracle via the OCI (Oracle Call Interface), no BDE needed Lower space requirement for installation (5 MB instead of 7 MB) Better performance Better support of Oracle 8 features Light version of the ER Diagrammer is part of Hora 4 Pre-Release of the PL/SQL Debugger is part of Hora 4 […]