COMMA_TO_TABLE converts a comma-separated string into a PL/SQL table.
Applicability
This content applies only to the Oracle-compatible mode of OceanBase Database.
Syntax
PROCEDURE COMMA_TO_TABLE( LIST IN VARCHAR2,
TABLEN OUT BINARY_INTEGER,
TAB OUT UNCL_ARRAY );
PROCEDURE COMMA_TO_TABLE( LIST IN VARCHAR2,
TABLEN OUT BINARY_INTEGER,
TAB OUT LNAME_ARRAY );
Parameters
| Parameter | Description |
|---|---|
| list | A comma-separated "name" list. |
| tablen | The number of rows in the PL/SQL table. |
| tab | A PL/SQL table that contains the name list. |
Examples
obclient> DECLARE
-> t_Vararray DBMS_UTILITY.UNCL_ARRAY;
-> Vc_Stringlist VARCHAR2(32767);
-> n_Idx BINARY_INTEGER;
-> BEGIN
-> Vc_Stringlist := 'dMl,dDl';
-> DBMS_UTILITY.Comma_To_Table(Vc_Stringlist, n_Idx, t_Vararray);
-> DBMS_OUTPUT.Put_Line(n_Idx);
-> FOR i IN 1 .. n_Idx LOOP
-> t_Vararray(i) := '[' || t_Vararray(i) || ']';
-> DBMS_OUTPUT.Put_Line(t_Vararray(i));
-> END LOOP;
-> END;
-> /
Query OK, 1 row affected (1.895 sec)