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

VIEW: SYS.CDB_DIM_CHILD_OF

Object Details
Object Name: CDB_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 in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the dimension
DIMENSION_NAME VARCHAR2 (30) 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_DIM_CHILD_OF;

Dependencies

[top of page]

SYS.CDB_DIM_CHILD_OF does not reference any database object

SYS.CDB_DIM_CHILD_OF is referenced by following:

SchemaPUBLIC
SynonymCDB_DIM_CHILD_OF