ALL_TYPES
describes the object types accessible to the current user.
DBA_TYPES
describes all object types in the database.
USER_TYPES
describes the object types owned by the current user. This view does not display the OWNER
column.
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 |
See Also: