Note
This view is available starting with V4.3.5 for V4.3.x.
For V4.2.x, this view is available starting with V4.2.5.
Purpose
USER_PLSQL_COLL_TYPES displays general information about collection types in packages of the current user. Only compiled packages can be displayed in this view.
Applicability
This view is available in OceanBase Database in Oracle mode only.
Columns
| Column | Type | Nullable | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TYPE_NAME | VARCHAR2(128) | NO | Type | ||||||||||
| COLUMN | TYPE | NULLABLE | Description | --- | --- | --- | --- | 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 | 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 | Indicates the length of the collection. | ||||||||||
| PRECISION | NUMBER(38) | NO | The precision. | ||||||||||
| SCALE | NUMBER(38) | NO | Indicates the scale. | ||||||||||
| COLUMN | VARCHAR2(44) | NO | The column name of the database object. | ||||||||||
| ELEM_STORAGE | VARCHAR2(7) | NO | Indicates the type of element storage. | ||||||||||
| NULLS_STORED | VARCHAR2(3) | NO | Specifies whether to store NULL values. | ||||||||||
| CHAR_USED | VARCHAR2(1) | NO | Displays whether character data type is used. | ||||||||||
| INDEX_BY | VARCHAR2(14) | NO | Indicates the index method. | ||||||||||
| ELEM_TYPE_MOD | VARCHAR2(7) | NO | Indicates element type modification. |
Sample query
obclient> SELECT * FROM USER_PLSQL_COLL_TYPES;
References
- To query the overall information about collection types defined in packages: ALL_PLSQL_COLL_TYPES.
- Query general collection type information defined in the current tenant's package: DBA_PLSQL_COLL_TYPES