36.4 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 wwv_flow_t_varchar2,
    p_string  IN VARCHAR2 )
    RETURN wwv_flow_t_varchar2;

Parameters

Table 36-4 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')