Purpose
ALL_TYPES displays user-defined types available in the database.
Related views
DBA_TYPES
USER_TYPES
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TYPE_NAME | VARCHAR2(64) | NO | The name of the type. |
| TYPE_OID | NUMBER(38) | NO | The object identifier (OID) of the type. |
| TYPECODE | VARCHAR2(10) | NO | The object type, for example, OBJECT and COLL. |
| ATTRIBUTES | NUMBER(38) | NO | The number of attributes in the type. |
| METHODS | NUMBER(38) | NO | The number of methods in the type. |
| PREDEFINED | CHAR(2) | NO | Indicates whether the type is a predefined type. |
| INCOMPLETE | CHAR(2) | NO | Indicates whether the type is incomplete, which means the object has only a name and has no methods or attributes. |
| FINAL | CHAR(3) | NO | Indicates whether the type is a non-inheritable type. |
| INSTANTIABLE | CHAR(3) | NO | Indicates whether the type is instantiable. |
| SUPERTYPE_OWNER | VARCHAR2(30) | NO | The owner of the supertype. |
| SUPERTYPE_NAME | VARCHAR2(30) | NO | The name of the supertype. |
| LOCAL_ATTRIBUTES | NUMBER(38) | NO | The number of local attributes. |
| LOCAL_METHODS | NUMBER(38) | NO | The number of local methods. |
| TYPEID | NUMBER(38) | YES | At present, this field is not supported and is NULL by default. |
