regular expressions

Search Strings REGEXP_SUBSTR

As of Oracle 10g, the SUBSTR has been enhanced to support searches for regular expressions. The new function is named REGEXP_SUBSTR. You can use the new function to perform advanced searches against a string.


REGEXP_SUBSTR(source_string, pattern
                               [, occurrence
                                   [, match_parameter]
source_string: is the text to search within