The regular expression functions available in Oracle Database 10g.
REGEXP_LIKE(x, pattern [, match_option])
Returns true when the source x matches the regular expression pattern.
You can change the default matching using match_option, which may be set to:
'c', which specifies case sensitive matching (default).
'i', which specifies case insensitive matching.
'n', which allows you to use the match-any-character operator.
'm', which treats x as multiple line.
REGEXP_INSTR(x, pattern [, start [, occurrence [, return_option [, match_option]]]])
Searches for pattern in x and returns the position at which pattern occurs.
You can supply an optional:
start position to begin the search.
occurrence that indicates which occurrence of pattern_exp should be returned.
return_option that indicates what integer to return. 0 specifies the integer to return is the position of the first character in x; non-zero specifies the integer to return is the position of the character in x after the occurrence.
match_option to change the default matching.
REGEXP_REPLACE(x, pattern [, replace_string [, start [, occurrence [, match_option]]]])
Searches x for pattern and replaces it with replace_string.
The other options have the same meaning as those shown earlier.
REGEXP_SUBSTR(x, pattern [, start [, occurrence [, match_option]]])
Returns a substring of x that matches pattern, which begins at the position specified by start.
The other options have the same meaning as those shown earlier.
Quote from:
Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)
# Paperback: 608 pages
# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)
# Language: English
# ISBN-10: 0072229810
# ISBN-13: 978-0072229813