TABLE_TO_STRING Function

54.34 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

Parameters	Description
`p_table`	The input table, assumes no holes and index starts at 1.
`p_sep`	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