43.12 PHRASE_EXISTS 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 PHRASE_EXISTS (
    p_phrase   IN VARCHAR2,    
    p_string   IN VARCHAR2 )
RETURN BOOLEAN;

Parameters

Table 43-9 PHRASE_EXISTS 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.phrase_exists(l_phrase,l_string) then
                  dbms_output.put_line('found');
              ELSE
                  dbms_output.put_line('NOT found');
              END IF;
          END;
          /          
          -> found