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

APEX_STRING_UTIL.PHRASE_EXISTS (
    p_phrase   IN VARCHAR2,    
    p_string   IN VARCHAR2 )
RETURN BOOLEAN;

Parameters

Returns

This function returns TRUE if the phrase was found. Otherwise, this function returns FALSE.

Example

The following example shows how to use the PHRASE_EXISTS 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