regex - REGEXP_LIKE to matchtwo words in a sentence in Oracle 11g -

sentence :"standard domain warning encountered in process"

i want identify sentences have words standard , warning in using regexp_like. search has case insensitive.

i want replace following code regexp_like:

select * table upper(sentence) 'standard%warning%' 

you can specify 'i' match parameter case insensitivity:

select * table regexp_like (sentence, '\bstandard(?=\b).*\bwarning\b', 'i')