Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-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_REFS

ALL_REFS describes the REF columns and REF attributes in object type columns accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Name of the owner
TABLE_NAME VARCHAR2(30) NOT NULL Name of the table
COLUMN_NAME VARCHAR2(4000)
Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name
WITH_ROWID VARCHAR2(3)
Indicates whether the REF value is stored with ROWID (YES) or not (NO)
IS_SCOPED VARCHAR2(3)
Indicates whether the REF column is scoped (YES) or not (NO)
SCOPE_TABLE_OWNER VARCHAR2(30)
Name of the owner of the scope table, if it exists and is accessible by the user
SCOPE_TABLE_NAME VARCHAR2(30)
Name of the scope table, if it exists and is accessible by the user
OBJECT_ID_TYPE VARCHAR2(16)
If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED