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

Part Number E10820-02
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
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 Owner of the table
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)   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(33)   Indicates whether the object ID (OID) is USER-DEFINED or SYSTEM GENERATED