55.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
APEX_STRING_UTIL.FIND_PHRASES (
p_phrases IN apex_t_varchar2,
p_string IN VARCHAR2 )
RETURN apex_t_varchar2;
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')
Parent topic: APEX_STRING_UTIL