1. API Reference
  2. APEX_STRING
  3. SPLIT_NUMBERS Function

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

p_str

The input varchar2.

p_sep

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