A MATCHING predicate searches character string literals for
pattern matches. The pattern string accepts the following pattern
characters:
o * Matches any string of zero or more characters
o % Matches any single character
matching-predicate =
---> value-expr -+------+-> MATCHING ------> <pattern>
+> NOT +
pattern =
----> char-value-expr ---->
Usage Notes
o If either of the expressions is null, the result is null.
o MATCHING predicate is not case sensitive; it considers
uppercase and lowercase forms of the same character to be a
match.
o The MATCHING predicate is not sensitive to diacritical
markings used in the DEC Multinational Character Set.
The following example shows the use of the MATCHING clause.
SQL> select last_name
cont> from employees
cont> where last_name matching '%on*';
LAST_NAME
Connolly
Lonergan
2 rows selected
SQL>