47.27 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 47-29 SPLIT_NUMBERS Function Parameters

Parameters	Description
p_str	The input varchar2.
p_sep	The separator. Splits at line feed by default. If null, split after each character. If a single character, split at this character. If more than 1 character, split at regular expression (max 512 characters).

Example

apex_string.split_numbers('1:2:3',':')
-> apex_t_number(1,2,3)