38.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 38-7 JOIN_CLOB Function Parameters
Parameters | Description |
---|---|
|
The input table. |
|
The separator, default is line feed. |
|
The duration of the |
Example
Concatenate numbers, separated by ':'.
apex_string.join_clob(apex_t_varchar2(1,2,3),':')
-> 1:2:3
Parent topic: APEX_STRING