Oracle Database regular expression functions and conditions accept a number of Perl-influenced operators that are in common use, although not part of the POSIX standard. Table C-3 lists those operators. For more complete descriptions with examples, please refer to Oracle Database Application Developer's Guide - Fundamentals.
Table C-3 Perl-influenced Operators in Oracle Regular Expressions
Operator | Description |
---|---|
\d |
A digit character. |
\D |
A nondigit character. |
\w |
A word character. |
\W |
A nonword character. |
\s |
A whitespace character. |
\S |
A non-whitespace character. |
\A |
Matches only at the beginning of a string, or before a newline character at the end of a string. |
\Z |
Matches only at the end of a string. |
*? |
Matches the preceding pattern element 0 or more times (nongreedy). |
+? |
Matches the preceding pattern element 1 or more times (nongreedy). |
?? |
Matches the preceding pattern element 0 or 1 time (nongreedy). |
{n}? |
Matches the preceding pattern element exactly |
{n,}? |
Matches the preceding pattern element at least |
{n,m}? |
Matches the preceding pattern element at least |