Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E17118-04 |
|
|
PDF · Mobi · ePub |
Table D-1 lists the full set of operators defined in the POSIX standard Extended Regular Expression (ERE) syntax. Oracle follows the exact syntax and matching semantics for these operators as defined in the POSIX standard for matching ASCII (English language) data. For more complete descriptions of the operators, examples of their use, and Oracle multilingual enhancements of the operators, refer to Oracle Database Advanced Application Developer's Guide. Notes following the table provide more complete descriptions of the operators and their functions, as well as Oracle multilingual enhancements of the operators. Table D-2 summarizes Oracle support for and multilingual enhancement of the POSIX operators.
Table D-1 Regular Expression Operators and Metasymbols
Operator | Description |
---|---|
\ |
The backslash character can have four different meanings depending on the context. It can:
|
* |
Matches zero or more occurrences |
+ |
Matches one or more occurrences |
? |
Matches zero or one occurrence |
| |
Alternation operator for specifying alternative matches |
^ |
Matches the beginning of a string by default. In multiline mode, it matches the beginning of any line anywhere within the source string. |
$ |
Matches the end of a string by default. In multiline mode, it matches the end of any line anywhere within the source string. |
. |
Matches any character in the supported character set except |
[ ] |
Bracket expression for specifying a matching list that should match any one of the expressions represented in the list. A non-matching list expression begins with a circumflex (^) and specifies a list that matches any character except for the expressions represented in the list. To specify a right bracket (]) in the bracket expression, place it first in the list (after the initial circumflex (^), if any). To specify a hyphen in the bracket expression, place it first in the list (after the initial circumflex (^), if any), last in the list, or as an ending range point in a range expression. |
( ) |
Grouping expression, treated as a single subexpression |
{m} |
Matches exactly m times |
{m,} |
Matches at least m times |
{m,n} |
Matches at least m times but no more than n times |
\n |
The backreference expression (n is a digit between 1 and 9) matches the nth subexpression enclosed between '(' and ')' preceding the \n |
[..] |
Specifies one collation element, and can be a multicharacter element (for example, [.ch.] in Spanish) |
[: :] |
Specifies character classes (for example, [:alpha:]). It matches any character within the character class. |
[==] |
Specifies equivalence classes. For example, [=a=] matches all characters having base letter 'a'. |