44.9 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 apex_t_varchar2,
p_sep IN VARCHAR2 DEFAULT apex_application.LF)
RETURN VARCHAR2
Parameters
Table 44-9 JOIN Function Signature 1 Parameters
Parameters | Description |
---|---|
|
The input table. |
|
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