Note
This view is available starting with V4.3.5 for V4.3.x.
It is available starting with V4.2.5 for V4.2.x.
Purpose
The USER_PLSQL_COLL_TYPES view displays general information about collection types defined in the current user's package. The types in the package can be displayed in this view only if the package is successfully compiled.
Applicability
This view applies only to OceanBase Database in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TYPE_NAME | VARCHAR2(128) | NO | The name of the PL/SQL collection type. |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package to which the PL/SQL collection type belongs. |
| COLL_TYPE | VARCHAR2(18) | NO | The type of the collection. |
| UPPER_BOUND | NUMBER(38) | NO | The upper bound of the collection. |
| ELEM_TYPE_OWNER | VARCHAR2(128) | NO | The owner of the element type. |
| ELEM_TYPE_NAME | VARCHAR2(136) | NO | The name of the element type. |
| ELEM_TYPE_PACKAGE | VARCHAR2(128) | NO | The name of the package to which the element type belongs. |
| LENGTH | NUMBER(38) | NO | The length of the collection. |
| PRECISION | NUMBER(38) | NO | The precision. |
| SCALE | NUMBER(38) | NO | The scale. |
| CHARACTER_SET_NAME | VARCHAR2(44) | NO | The name of the character set. |
| ELEM_STORAGE | VARCHAR2(7) | NO | The storage type of the element. |
| NULLS_STORED | VARCHAR2(3) | NO | Indicates whether null values are stored. |
| CHAR_USED | VARCHAR2(1) | NO | Indicates whether the character data type is used. |
| INDEX_BY | VARCHAR2(14) | NO | The indexing method. |
| ELEM_TYPE_MOD | VARCHAR2(7) | NO | The modification of the element type. |
Sample query
obclient> SELECT * FROM USER_PLSQL_COLL_TYPES;
References
- Query general information about collection types defined in a package: ALL_PLSQL_COLL_TYPES.
- Query general information about collection types defined in the current tenant's package: DBA_PLSQL_COLL_TYPES