Oracle SQL - Influencing Matching Behavior


You can influence the matching behavior of the regular expression functions with their options argument.

The following table shows the values you can specify in the options function argument.

Option Description
i Case-insensitive search (no distinction between uppercase and lowercase)
c Case-sensitive search
n Allows the period . to match the newline character
m Treat text as multiple lines; ^ and $ refer to the beginning and end of any of those lines

You can specify one or more of these values.

If you specify conflicting combinations, such as ic, the Oracle DBMS uses the last value (c) and ignores the first one.

The default behavior for case-sensitivity depends on the NLS_SORT parameter value.

Related Topic