40.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 40-9 JOIN Function Signature 2 Parameters
Parameters | Description |
---|---|
|
The input table. |
|
The separator, default is line feed. |
Example
Concatenate numbers, separated by ':'.
apex_string.join(apex_t_number(1,2,3),':')
-> 1:2:3
Parent topic: APEX_STRING