Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
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_TYPES

ALL_TYPES describes the object types accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the type
TYPE_NAME VARCHAR2(128)   Name of the type
TYPE_OID RAW(16)   Object identifier (OID) of the type
TYPECODE VARCHAR2(128)   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(128)   Owner of the supertype (NULL if type is not a subtype)
SUPERTYPE_NAME VARCHAR2(128)   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