49.26 SPLIT_CLOBS Function

This function splits input clobs at the separator and returns a table of clobs.

Syntax

APEX_STRING.SPLIT_CLOBS (
  p_str   IN CLOB,
  p_sep   IN VARCHAR2    DEFAULT apex_application.LF,
  p_limit IN PLS_INTEGER DEFAULT NULL )
RETURN apex_t_clob;

Parameters

Table 49-28 XX Parameters

Parameter	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).
p_limit	Maximum number of splits. Ignored if null. If smaller than the total possible number of splits, the last table element contains the rest.

Example

apex_string.split_clobs('1:2:3',':')
-> apex_t_clob('1','2','3')