JOIN Function Signature 1

54.11 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

APEX_STRING.JOIN (
   p_table IN apex_t_varchar2,
   p_sep IN VARCHAR2 DEFAULT apex_application.LF )
   RETURN VARCHAR2

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

Parent topic: APEX_STRING