| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_DIM_LEVELS describes the dimension levels accessible to the current user. All columns of a dimension level must come from the same relation.
DBA_DIM_LEVELS describes all dimension levels in the database.
USER_DIM_LEVELS describes the levels of all dimensions owned by the current user.
| 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 |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
