ALL_DIM_CHILD_OF describes hierarchical relationships of 1 to n between the pairs of levels in the dimensions accessible to the current user.
Related Views
DBA_DIM_CHILD_OF describes all such hierarchical relationships in the database.
USER_DIM_CHILD_OF describes all such hierarchical attributes in the current user's schema.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the dimension |
|
|
|
|
Name of the dimension |
|
|
|
Hierarchy name |
|
|
|
|
|
Hierarchical position within this hierarchy, position 1 being the most detailed |
|
|
|
Child side of 1:n relationship |
|
|
|
|
If non-null, then the child joins to the parent |
|
|
|
|
Parent side of 1:n relationship in relation to the |
See Also: