The TABLE_TO_COMMA stored procedure converts a PL table of names into a list of names delimited by commas (,). Values of the PL table are 1..n, and n+1 is NULL, which indicates the end.
Note
In the current OceanBase Database version, the DBMS_UTILITY package does not support the UTF-16 character set.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_UTILITY.TABLE_TO_COMMA (
tab IN UNCL_ARRAY,
tablen OUT BINARY_INTEGER,
list OUT VARCHAR2);
DBMS_UTILITY.TABLE_TO_COMMA (
tab IN lname_array,
tablen OUT BINARY_INTEGER,
list OUT VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| tab | The PL table that contains a list of table names. |
| tablen | The number of tables in the PL table. |
| list | The list of tables delimited by commas (,). |
Return values
A list of tables delimited by commas (,) and the number of elements in the tables are returned.