3.131 ALL_TYPES

ALL_TYPES describes the object types accessible to the current user.

Related Views

  • 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(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)

PERSISTABLE

VARCHAR2(3)

Indicates whether the type is a persistable 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

See Also: