49.29 TABLE_TO_STRING Function
This function returns the values of the apex_application_global.vc_arr2
input table p_table
as a concatenated varchar2
, separated by p_sep
.
Syntax
FUNCTION TABLE_TO_STRING (
p_table IN apex_application_global.vc_arr2,
p_sep IN VARCHAR2 DEFAULT ':' )
RETURN VARCHAR2;
Parameters
Table 49-31 TABLE_TO_STRING Function Parameters
Parameters | Description |
---|---|
|
The input table, assumes no holes and index starts at 1. |
|
The separator, default is |
Example
Concatenate numbers, separated by ':'
.
declare
l_table apex_application_global.vc_arr2;
begin
l_table(1) := 'a';
l_table(2) := 'b';
l_table(3) := 'c';
sys.dbms_output.put_line(apex_string.table_to_string(l_table));
end;
-> a:b:c
Parent topic: APEX_STRING