Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_DIM_LEVELS

ALL_DIM_LEVELS describes the dimension levels accessible to the current user. All columns of a dimension level must come from the same relation.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the dimension
DIMENSION_NAME VARCHAR2(30) NOT NULL Name of the dimension
LEVEL_NAME VARCHAR2(30)
Unique within a dimension
NUM_COLUMNS NUMBER
Number of columns in the level definition
DETAILOBJ_OWNER VARCHAR2(30) NOT NULL Owner of the detail object that the keys of this level come from
DETAILOBJ_NAME VARCHAR2(30) NOT NULL Name of the table that the keys of this level come from
SKIP_WHEN_NULL VARCHAR2(1)   Indicates whether the level is declared with the SKIP WHEN NULL clause (Y) or not (N)