match_param parameter that allows to change the default matching behaviour of these functions. match_param can be any combination of the following letters: i | for case-insensitive matching |
c | for case-sensitive matching |
n | lets the dot (.) also match the new line character. |
m | treats the source text as a multi line text: ^ and $ match not only at the beginning and end of the source text but also where new line characters occur in text |
x | ignores whitespace characters in the pattern. This is used for more readable patterns. |
NLS_SORT. select regexp_replace('foo42barBAZ etc.', '.*\d([a-z]+).*', '\1', 1, 1, 'c') from dual;
select regexp_replace('foo42barBAZ etc.', '.*\d([a-z]+).*', '\1', 1, 1, 'i') from dual;