2.119 ALL_DIM_LEVEL_KEY
ALL_DIM_LEVEL_KEY
describes a column of a dimension level accessible to the current user. The position of a column within a level is specified by KEY_POSITION
.
Related Views
-
DBA_DIM_LEVEL_KEY
describes all columns of dimension levels in the database. -
USER_DIM_LEVEL_KEY
describes all columns of dimension levels owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the dimension |
|
|
|
Name of the dimension |
|
|
|
Name of the hierarchy level |
|
|
|
Ordinal position of the key column within the level |
|
|
|
Name of the key column |
See Also: