42.25 SPLIT Function Signature 2

Use this function to split input clob at separator.

Syntax

SPLIT (
    p_str IN CLOB,
    p_sep IN VARCHAR2 DEFAULT apex_application.LF )
    RETURN apex_t_varchar2;

Parameters

Table 42-27 SPLIT Function Signature 2 Parameters

Parameters	Description
p_str	The input clob.
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('1:2:3',':')
-> apex_t_varchar2('1','2','3')