Feature
ALL_COLL_TYPES displays user-defined collection types available in the database. Its fields are the same as those in the DBA_COLL_TYPES view.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_COLL_TYPES
USER_COLL_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. |
| COLL_TYPE | VARCHAR2(10) | NO | The type of the collection. Valid values: |
| UPPER_BOUND | NUMBER(38) | YES | The maximum size for collections of the VARYING type. |
| ELEM_TYPE_MOD | VARCHAR2(7) | YES | At present, this field is not supported and is NULL by default. |
| ELEM_TYPE_OWNER | VARCHAR2(128) | YES | The owner of the collection element type. |
| ELEM_TYPE_NAME | VARCHAR2(324) | YES | The name of the collection element type. |
| LENGTH | NUMBER(38) | YES | The length of the collection element type. |
| NUMBER_PRECISION | NUMBER(38) | YES | The precision of the collection element type. |
| SCALE | NUMBER(38) | YES | The number of digits on the right of the decimal point of the collection element type. |
| CHARACTER_SET_NAME | CHAR(7) | YES | The name of the character set for the collection element type. |
| ELEM_STORAGE | CHAR(3) | YES | At present, this field is not supported and is NULL by default. |
| NULLS_STORED | CHAR(1) | YES | At present, this field is not supported and is NULL by default. |