25.7 JOIN Function Signature 1

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

Syntax

join (
   p_table in wwv_flow_t_varchar2,
   p_sep in varchar2 default wwv_flow.LF)
   return varchar2

Parameters

Table 25-7 JOIN Function Signature 1 Parameters

Parameters Description

p_table

The input table.

p_sep

The separator, default is line feed.

Example

Concatenate numbers, separated by ':'.

apex_string.join(apex_t_varchar2('a','b','c'),':')
-> a:b:c