| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |
VARCHAR2(30) |
NOT NULL |
Owner of the dimension |
DIMENSION_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the dimension |
HIERARCHY_NAME |
VARCHAR2(30) |
Hierarchy name | |
POSITION |
NUMBER |
NOT NULL |
Hierarchical position within this hierarchy, position 1 being the most detailed |
CHILD_LEVEL_NAME |
VARCHAR2(30) |
Child side of 1:n relationship | |
JOIN_KEY_ID |
VARCHAR2(40) |
If non-null, then the child joins to the parent | |
PARENT_LEVEL_NAME |
VARCHAR2(30) |
Parent side of 1:n relationship in relation to the CHILD_LEVEL_NAME |
