Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_DIM_JOIN_KEY

ALL_DIM_JOIN_KEY describes the joins between two dimension tables that are accessible to the current user. The join is always specified between a parent dimension level column and a child column.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the dimension
DIMENSION_NAME VARCHAR2(30) NOT NULL Name of the dimension
DIM_KEY_ID NUMBER NOT NULL Join key ID (unique within a dimension)
LEVEL_NAME VARCHAR2(30)   Name of the hierarchy level
KEY_POSITION NUMBER NOT NULL Ordinal position of the key column within the level
HIERARCHY_NAME VARCHAR2(30)   Name of the hierarchy
CHILD_JOIN_OWNER VARCHAR2(30) NOT NULL Owner of the join column table
CHILD_JOIN_TABLE VARCHAR2(30) NOT NULL Name of the join column table
CHILD_JOIN_COLUMN VARCHAR2(30) NOT NULL Name of the join column
CHILD_LEVEL_NAME VARCHAR2(30)   Name of the child hierarchy level of the join key