38.22 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 38-24 SPLIT Function Signature 2 Parameters
Parameters | Description |
---|---|
|
The input clob. |
|
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