Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
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
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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_COLUMN VARCHAR2(30) NOT NULL Name of the join column