 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
The database dimension hierarchy report should be
reviewed to ensure that the hierarchies are using the proper level
assignments and that the parent-child relationships make sense (that
is, they aren’t inverted).
dim_attribute.sql
COLUMN owner FORMAT a8 HEADING 'Owner'
COLUMN dimension_name FORMAT a10 HEADING 'Dimension|Name'
COLUMN column_name FORMAT a20 HEADING 'Column|Name'
COLUMN level_name FORMAT a20 HEADING 'Level|Name'
COLUMN inferred FORMAT a10 HEADING 'Inferred'
BREAK ON owner ON level_name
SET PAGES 58 LINES 78 FEEDBACK OFF VERIFY OFF
ttitle 'Database OPERATOR Report'
SPOOL dim_attribute.lis
SELECT
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
