1. API Reference
  2. APEX_STRING
  3. SPLIT Function Signature 2

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 32-21 SPLIT Function Signature 2 Parameters

Parameters Description

p_str

The input clob.

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('1:2:3',':')
-> apex_t_varchar2('1','2','3')

Parent topic: APEX_STRING