|
 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
a.owner,
a.dimension_name,
b.level_name,
c.column_name,
c.inferred
FROM
dba_dimensions a,
dba_dim_levels b,
dba_dim_attributes c
SEE CODE DEPOT FOR FULL SCRIPT
ORDER BY
a.owner,
a.dimension_name,
b.level_name;
SPOOL OFF
CLEAR BREAKS
CLEAR COLUMNS
TTITLE OFF
SET FEEDBACK ON VERIFY ON
Here is a sample listing.
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|