|
 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
COLUMN
owner FORMAT a8 HEADING 'Owner'
COLUMN dimension_name FORMAT a10 HEADING 'Dimension|Name'
COLUMN column_name FORMAT a10 HEADING 'Column|Name'
COLUMN hierarchy_name FORMAT a10 HEADING 'Hierarchy|Name'
COLUMN parent_level_name FORMAT a10 HEADING 'Parent|Level'
COLUMN child_level_name FORMAT a10 HEADING 'Child|Level'
COLUMN join_key_id FORMAT a20 HEADING 'Join Key|ID'
BREAK ON owner ON dimension_name
SET PAGES 58 LINES 78 FEEDBACK OFF VERIFY OFF
ttitle 'Database Dimension Hierarchy Report'
SPOOL dim_hierarchies.lis
SELECT
a.owner,
a.dimension_name,
b.hierarchy_name,
c.parent_level_name,
c.child_level_name,
c.join_key_id
FROM
dba_dimensions a,
dba_dim_hierarchies b,
dba_dim_child_of c
SEE CODE DEPOT FOR FULL SCRIPT
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|