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
p_phrase	The given phrase.
p_string	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