 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
SEE CODE DEPOT FOR FULL SCRIPT
AND
a.dimension_name=c.dimension_name
AND
b.hierarchy_name=c.hierarchy_name
ORDER BY
a.owner,
a.dimension_name,
b.hierarchy_name;
SPOOL OFF
CLEAR BREAKS
CLEAR COLUMNS
TTITLE OFF
SET FEEDBACK ON VERIFY ON
Example of output from database dimension
hierarchy
ORTEST1
database
Dimension
Hierarchy Parent Child
Join Key
Owner Name
Name Level
Level ID
-------- ---------- ---------- ---------- ---------- --------------
TELE_DBA TEST_DIM PLAN
PARENT_ID CHILD_ID
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
