36.3 FIND_PHRASE Function
This function returns whether the given phrase is in p_string
. The
search is case insensitive and also ignores white space and special characters.
Syntax
FUNCTION FIND_PHRASE (
p_phrase IN VARCHAR2,
p_string IN VARCHAR2 )
RETURN BOOLEAN;
Parameters
Table 36-3 FIND_PHRASE Function Parameters
Parameter | Description |
---|---|
|
The given phrase. |
|
The input string. |
Returns
This function returns True if the phrase was found. Otherwise, this function returns False.
Example
The following example shows how to use the FIND_PHRASE
function.
declare
l_phrase varchar2(4000) := 'sqldeveloper';
l_string varchar2(4000) := 'how now brown cow sqldeveloper? sql developer.';
begin
if apex_string_util.find_phrase(l_phrase,l_string) then
dbms_output.put_line('found');
else
dbms_output.put_line('NOT found');
end if;
end;
/
-> found
Parent topic: APEX_STRING_UTIL