Organization of This Book

This book is divided into the following six sections:


You’re reading it now.


Provides a short regular expression tutorial aimed at those who aren’t already familiar with regular expressions.

Oracle’s Regular Expression Support

For readers familiar with regular expressions, describes how they are implemented and used within Oracle. Also includes a description of the key differences between the regular expression implementations of Perl and Oracle.

Regular Expression Quick Reference

Describes the regular expression metacharacters supported by Oracle and provides examples of their usage.

Oracle Regular Expression Functions

Details the new SQL and PL/SQL functions that make up Oracle’s regular expression support.

Oracle Regular Expression Error Messages

Lists all of Oracle’s regular expression error messages and provides advice as to what do when you encounter a given message.

Get Oracle Regular Expressions Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.