45.7 FIND_PHRASES Function

This function finds the occurrences of p_string in p_phrase return in an array. The search is case insensitive and also ignores white space and special characters.

Syntax

FUNCTION FIND_PHRASES (
    p_phrases IN apex_t_varchar2,
    p_string  IN VARCHAR2 )
    RETURN apex_t_varchar2;

Parameters

Table 45-5 FIND_PHRASES Function Parameters

Parameter	Description
p_phrases	A table of phrases.
p_string	The input string.

Returns

This function returns an array of phrases that were found, without duplicates.

Example

DECLARE
    l_phrases apex_t_varchar2 := apex_t_varchar2();
    l_arr     apex_t_varchar2 := apex_t_varchar2();
    l_string varchar2(4000) := 'how now brown cow';
BEGIN
    apex_string.push(l_phrases,'brown');
    apex_string.push(l_phrases,'cow');
    apex_string.push(l_phrases,'brown cow');
    l_arr := apex_string_util.find_phrases(l_phrases,l_string);
END;
    /
    apex_t_varchar2('brown','cow','brown cow')