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: