SPLIT_MUTLIPLE_VALUE_TO

45.54 SPLIT_MUTLIPLE_VALUE_TO_TABLE Function

This function converts a separated input string into an array.

Syntax

APEX_PLUGIN_UTIL.SPLIT_MUTLIPLE_VALUE_TO_TABLE (
    p_value IN CLOB,
    p_item  IN apex_plugin_api.t_item )
    RETURN apex_t_varchar2;

Parameters

Parameter	Description
`p_value`	The input value.
`p_item`	This type contains information about the current item.

Returns

An array of strings.

Example

DECLARE
    l_arr  apex_t_varchar2 := apex_t_varchar2();
    l_item apex_plugin.t_item;
BEGIN
    l_arr := apex_plugin_util.split_multiple_value_to_table(
                 p_value => '["dog","cat","capybara"]',
                 p_item  => l_item
             );
END;
/
-> apex_t_varchar2('dog','cat','capybara')

Parent topic: APEX_PLUGIN_UTIL