Oracle Regular Expressions Pocket Reference
Tutorial & Quick Reference
Publisher: O'Reilly Media
Final Release Date: September 2003
Pages: 66

Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data.This concise pocket guide 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.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews


by PowerReviews
oreillyOracle Regular Expressions Pocket Reference

(based on 2 reviews)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 2 customers

Displaying reviews 1-2

Back to top


Excellent resource for Regex in Oracle

By morlamweb

from USA

About Me Developer

Verified Buyer


  • Helpful examples


    Best Uses

      Comments about oreilly Oracle Regular Expressions Pocket Reference:

      This book is a great reference for regular expressions in Oracle Database. I found the official documentation somewhat lacking in details and explanation. This book neatly fills in the gaps. I'm familiar with regexes in other contexts, but Oracle presented a few unique challenges, and this book answered all of my questions. Money well spent.

      (1 of 2 customers found this review helpful)


      Oracle Regular Expressions Pocket Reference Review

      By Srinivas

      from Undisclosed

      Comments about oreilly Oracle Regular Expressions Pocket Reference:

      Oracle Regular Expressions

      This book covers one of the most exciting features of Oralce 10G, i.e Regular Expressions. Till Oracle 10G, Oracle was supporting only LIKE predicate for pattern matching. This Book covers all 4 functions (REGEXP_INSTR, REGEXP_LIKE, REGEXP_REPLACE, REGEXP_SUBSTR) of Regular expression supported by Oracle. It is for both novice users who didn't use Regular expressions till now and for the users who used other languages like Perl, UNIX grep command etc.,

      We can use this book as quick reference or regular expression tutorial also. It not only explains what oracle supports as far as Regular Expressions is concerned, it also covers the difference between Perl and Oracle.

      Finally it covers a list of error messages you may encounter and explanation and how to resolve them. This book is almost like a complete reference for Regular expression (hope I should write this sentence after getting experience on Oracle 10G).


      Displaying reviews 1-2

      Back to top

      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook:  $7.99
      Formats:  DAISY, ePub, Mobi, PDF
      Print & Ebook:  $10.95
      Print:  $9.95