The ALL_TYPES view provides the information about the object types available to the current user.

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:
  • OBJECT
  • COLLECTION
  • OTHER
attributes INTEGER The number of attributes in the type.