DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_DIM_CHILD_OF

Object Details
Object Name: ALL_DIM_CHILD_OF
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Representaion of a 1:n hierarchical relationship between a pair of levels in
a dimension

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the dimension
DIMENSION_NAME VARCHAR2 (128) Yes Name of the dimension
HIERARCHY_NAME VARCHAR2 (128)
Name of the hierarchy
POSITION NUMBER
Yes Hierarchical position within this hierarchy, position 1 being the most detailed
CHILD_LEVEL_NAME VARCHAR2 (128)
Name of the child-side level of this 1:n relationship
JOIN_KEY_ID VARCHAR2 (40)
Keys that join child to the parent
PARENT_LEVEL_NAME VARCHAR2 (128)
Name of the parent-side level of this 1:n relationship
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      DIMENSION_NAME
,      HIERARCHY_NAME
,      POSITION
,      CHILD_LEVEL_NAME
,      JOIN_KEY_ID
,      PARENT_LEVEL_NAME
FROM SYS.ALL_DIM_CHILD_OF;

Dependencies

[top of page]

SYS.ALL_DIM_CHILD_OF references the following:

SchemaSYS
ViewDBA_DIM_CHILD_OF
TableOBJ$
TableOBJAUTH$
TableUSER$
SYS.ALL_DIM_CHILD_OF is referenced by following:

SchemaPUBLIC
SynonymALL_DIM_CHILD_OF
SchemaSYS
Package BodyDBMS_CUBE - show dependent code
Package BodyDBMS_DIMENSION - show dependent code
Package BodyDBMS_SUMVDM - show dependent code