SPLIT_CLOBS Function

55.32 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

Parameter Description

p_str The input clob.

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.

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')

Parent topic: APEX_STRING