Oracle Regular Expressions Pocket Reference

Oracle Regular Expressions Pocket Reference is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.

Table of Contents

Introduction 


     Tutorial
               Patterns 

               Regular Expressions 

               Bracket Expressions 

            The Escape Character
               Subexpressions 

               Alternation 

               Greediness 

               Backreferences 

               Fuzziness 


     Oracle's Regular Expression Support 

               Regular Expression Functions

               Regular Expression Locale Support 

               Regular Expression Matching Options 

               Standards Compliance 

            Differences Between Perl and Oracle
     Regular Expression Quick Reference 

              \ (Backslash)

              \1 through \9 (Backslash)

              . (Period)

              ^ (Caret)

              $ (Dollar Sign)

              [ ] (Square Brackets)

              [.  .] (Collation Element)

              [:  :] (Character Class)

              [=  =] (Equivalence Class)

              * (Asterisk)

              + (Plus Sign)

              ? (Question Mark)

              { } (Curly Braces)

              Vertical Bar (|)

              ( ) (Parentheses)


     Oracle Regular Expression Functions 

              REGEXP_INSTR

              REGEXP_LIKE

              REGEXP_REPLACE

              REGEXP_SUBSTR


     Oracle Regular Expression Error Messages 

              ORA-01760: illegal argument for function

              ORA-12722: regular expression internal error

              ORA-12725: unmatched parentheses in regular expression

              ORA-12726: unmatched bracket in regular expression

            ORA-12727: invalid back reference in regular expression
              ORA-12728: invalid range in regular expression

              ORA-12729: invalid character class in regular expression:

            ORA-12730: invalid equivalence class in regular expression
              ORA-12731: invalid collation class in regular expression

              ORA-12732: invalid interval value in regular expression