Oracle 10g Meta Characters


Symbol
Description
*
Matches zero or more occurrences
|
Alteration operator for specifying alternative matches
 ^/$
Matches the start-of-line/end-of-line
[ ]
Bracket expression for a matching list matching any one of the expressions represented in the list
{m}
Matches exactly m times
{m,n}
Matches at least m times but no more than n times
[: :]
Specifies a character class and matches any character in that class
\
Can have 4 different meanings: 1. Stand for itself. 2. Quote the next character. 3. Introduce an operator. 4. Do nothing.
+
Matches one or more occurrence
?
Matches zero or one occurrence
.
Matches any character in the supported character set, except NULL
()
Grouping expression, treated as a single sub expression
[==]
Specifies equivalence classes
\n
Back-reference expression
[..]
Specifies one collation element, such as a multi character element

1 comment:

Louis Perkins said...

Very helpful post! This is crucial for product information management.