The DBA_TYPES view provides the information about all object types in the database.

Parameter Type Description
owner TEXT The owner of an object type.
schema_name TEXT The name of the schema in which a type is defined.
type_name TEXT The name of the type.
type_oid OID The object identifier (OID) of the type.
typecode TEXT The typecode of the type. Valid values:
attributes INTEGER The number of attributes in the type.