47.8 JOIN_CLOBS Function

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

Syntax

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

Parameters

Table 47-8 APEX_STRING.JOIN_CLOBS 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 ':'.

apex_string.join_clobs(apex_t_clob('1','2','3'),':')
-> 1:2:3