DBA Data[Home] [Help]

VIEW: SYS.CDB_DIM_JOIN_KEY

Source

View Text - Preformatted

SELECT "OWNER","DIMENSION_NAME","DIM_KEY_ID","LEVEL_NAME","KEY_POSITION","HIERARCHY_NAME","CHILD_JOIN_OWNER","CHILD_JOIN_TABLE","CHILD_JOIN_COLUMN","CHILD_LEVEL_NAME","CON_ID" FROM CONTAINERS("SYS"."DBA_DIM_JOIN_KEY")
View Text - HTML Formatted

SELECT "OWNER"
, "DIMENSION_NAME"
, "DIM_KEY_ID"
, "LEVEL_NAME"
, "KEY_POSITION"
, "HIERARCHY_NAME"
, "CHILD_JOIN_OWNER"
, "CHILD_JOIN_TABLE"
, "CHILD_JOIN_COLUMN"
, "CHILD_LEVEL_NAME"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_DIM_JOIN_KEY")