ALL_TYPES v17

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

NameTypeDescription
ownerTEXTOwner of the object type.
schema_nameTEXTName of the schema in which the type is defined.
type_nameTEXTName of the type.
type_oidOIDObject identifier (OID) of the type.
typecodeTEXTTypecode of the type. Possible values are: OBJECT, COLLECTION, OTHER
attributesINTEGERNumber of attributes in the type.