Return
-
Title
Enhancements for way SQL is formatted in the Spool File window in version 6 -
Description
We find the spool file format style in version 6 difficult to read and un-SQL*Plus-like. Please make these changes to address this.
1) Revert back to SQL Nav 5 formatting style. We would characterize version 5 style as clean, easy to interpret vs version 6 which is cluttery, overloaded with too many formatting symbols.Example of SQL Nav 6 format:
**** SCRIPT STARTED Session:USER@DEV06(2) 09/16/2011 1:48:33 PM ****
select sysdate from dual
==>
SYSDATE
------------------------
09/16/2011 1:48:33 PM
-------- End of Data --------
1 row(s) fetched
--------------------------------------------------------------------------------
**** SCRIPT ENDED 09/16/2011 1:48:33 PM ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Example of SQL Nav 5 style:
*** SCRIPT START : Session:USER@DEV06(1) 09/16/2011 1:42:03 PM ***
Processing ...
select sysdate from dualQuery finished, retrieving results...
SYSDATE
----------------------
09/16/2011 1:42:03 PM1 row(s) retrieved
*** SCRIPT END : Session:USER@DEV06(1) 09/16/2011 1:42:03 PM ***
2) When DDL is executed, display Oracle's SQL*Plus feedback in the spool file.Example current version 6 format:**** SCRIPT STARTED Session: USER@DEV06(3) 09/16/2011 2:04:25 PM ****
alter procedure disable_fks compile
==>
SQL statement executed
--------------------------------------------------------------------------------
**** SCRIPT ENDED 09/16/2011 2:04:25 PM ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^What we would like instead
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.