33.9 JOIN Function Signature 2

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

Syntax

join (
   p_table in apex_t_number,
   p_sep in varchar2 default apex_application.LF )
   return varchar2

Parameters

Table 33-9 JOIN Function Signature 2 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_number(1,2,3),':')
-> 1:2:3