SPLIT_NUMBERS Function
Use this function to split input at separator, values must all be numbers.
Syntax
split_numbers (
p_str in varchar2,
p_sep in varchar2 default apex_application.LF )
return apex_t_number;
Parameters
Table 32-22 SPLIT_NUMBERS Function Parameters
Parameters | Description |
---|---|
|
The input varchar2. |
|
The separator. If null, split after each character. If a single character, split at this character. If more than 1 character, split at regular expression. The default is to split at line feed. |
Example
apex_string.split_numbers('1:2:3',':')
-> apex_t_number(1,2,3)
Parent topic: APEX_STRING