JOIN_CLOBS Function

55.10 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

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

Parent topic: APEX_STRING