44.7 JOIN_CLOB Function

Returns the values of the apex_t_varchar2 input table p_table as a concatenated clob, separated by p_sep.

Syntax

JOIN_CLOB (
    p_table IN apex_t_varchar2,
    p_sep   IN VARCHAR2    DEFAULT apex_application.LF,
    p_dur   IN PLS_INTEGER DEFAULT sys.dbms_lob.call )
    RETURN CLOB

Parameters

Table 44-7 JOIN_CLOB Function Parameters

Parameters	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

Concatenate numbers, separated by ':'.

apex_string.join_clob(apex_t_varchar2('1','2','3'),':')
-> 1:2:3