| |
 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
COLUMN sql_text
FORMAT a40 HEADING 'SQL Outlined' WORD_WRAPPED
BREAK ON owner ON category
SET PAGES 58 LINES 130 FEEDBACK OFF VERIFY OFF
ttitle 'Database OUTLINE Report'
SPOOL outline.lis
SELECT
owner,
name,
category,
used,
to_char(timestamp,'dd/mm/yyyy hh24:mi') timestamp ,
version,
sql_text
FROM
dba_outlines
SEE CODE DEPOT FOR FULL SCRIPT
ORDER BY
owner,
category;
SPOOL OFF
CLEAR BREAKS
TTITLE OFF
SET FEEDBACK ON VERIFY ON
Here is a sample listing.
Outline Category Date Last
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
