12.5.1 String Comparison Functions

Normally, if any expression in a string comparison is case sensitive, the comparison is ... Pattern matching using SQL simple regular expression comparison.

docs.oracle.com