TABLE_TO_CLOB Function

55.35 TABLE_TO_CLOB Function

This function returns the values of the apex_application_global.vc_arr2 input table p_table as a concatenated clob, separated by p_sep.

Syntax

APEX_STRING.TABLE_TO_CLOB (
    p_table IN apex_application_global.vc_arr2,
    p_sep   IN VARCHAR2             DEFAULT apex_application.LF,
    p_dur   IN PLS_INTEGER          DEFAULT sys.dbms_lob.call )
    RETURN CLOB;

Parameters

Parameter	Description
`p_table`	The input table.
`p_sep`	The separator. Default is line feed.
`p_dur`	The duration of the clob. Default `sys.dbms_lob.call`.

Example

The following example concatenates numbers, separated by ':'

DECLARE
    l_table apex_application_global.vc_arr2;
BEGIN
    l_table(1) := '1';
    l_table(2) := '2';
    l_table(3) := '3';

    sys.dbms_output.put_line(apex_string.table_to_clob(l_table, ':'));
END;
-> 1:2:3

Parent topic: APEX_STRING