Note
This view is available starting with V4.3.5 for V4.3.x.
This view is available starting with V4.2.5 for V4.2.x.
Purpose
The USER_PLSQL_COLL_TYPES view displays the general information about collection types defined in the current user's package. The types in the package are displayed in this view only after the package is successfully compiled.
Applicability
This view is available only in Oracle mode of OceanBase Database.
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 to store NULL values. |
| CHAR_USED | VARCHAR2(1) | NO | Indicates whether to use the character data type. |
| 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 the general information about collection types defined in a package: ALL_PLSQL_COLL_TYPES.
- Query the general information about collection types defined in the current tenant's package: DBA_PLSQL_COLL_TYPES