35.23 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 35-25 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