| Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
| Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
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 times (nongreedy). |
| {n,}? | Matches the preceding pattern element at least n times (nongreedy). |
| {n,m}? | Matches the preceding pattern element at least n but not more than m times (nongreedy). |
