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

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

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

ALL_TYPES

ALL_TYPES describes the object types accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the type
TYPE_NAME VARCHAR2(30) NOT NULL Name of the type
TYPE_OID RAW(16) NOT NULL Object identifier (OID) of the type
TYPECODE VARCHAR2(30)   Typecode of the type
ATTRIBUTES NUMBER   Number of attributes (if any) in the type
METHODS NUMBER   Number of methods (if any) in the type
PREDEFINED VARCHAR2(3)   Indicates whether the type is a predefined type (YES) or not (NO)
INCOMPLETE VARCHAR2(3)   Indicates whether the type is an incomplete type (YES) or not (NO)
FINAL VARCHAR2(3)   Indicates whether the type is a final type (YES) or not (NO)
INSTANTIABLE VARCHAR2(3)   Indicates whether the type is an instantiable type (YES) or not (NO)
SUPERTYPE_OWNER VARCHAR2(30)   Owner of the supertype (NULL if type is not a subtype)
SUPERTYPE_NAME VARCHAR2(30)   Name of the supertype (NULL if type is not a subtype)
LOCAL_ATTRIBUTES NUMBER   Number of local (not inherited) attributes (if any) in the subtype
LOCAL_METHODS NUMBER   Number of local (not inherited) methods (if any) in the subtype
TYPEID RAW(16)   Type ID value of the type