Oracle Regular Expressions Pocket 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 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top

(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 review 1

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