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 32-6 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