Oracle Regular Expressions Pocket Reference

BUY THIS BOOK

Print Book $9.95

Print+PDF $12.93

PDF $7.99

Safari Books Online

What is this?

Print Book £6.95

What is this?

Looking to Reprint or License this content?

Tell a friend

Oracle Regular Expressions Pocket Reference

By Jonathan Gennick, Peter Linsley
First Edition September 2003
Pages: 64
Series: Pocket References
ISBN 10: 0-596-00601-2 | ISBN 13: 9780596006013
(Average of 1 Customer Reviews)

Book description

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.
Full Description

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.

Post-purchase benefits:

Browse within this book

Cover | Table of Contents | Sample Excerpt

Book details

First Edition: September 2003
Series: Pocket References
ISBN: 0-596-00601-2
Pages: 64
Average Customer Reviews: (Based on 1 Reviews)

Featured customer reviews

Oracle Regular Expressions Pocket Reference Review, September 29 2003

Rating:

Submitted by Srinivas [Respond | View]

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).

Srinivas.

Read all reviews

Media reviews
"The book explains the use of the regular expressions very well with clearly written examples. For this book too, you can download a sample table with data to test the regular expressions yourself. I find regular expressions really powerful and one of the most underestimated/(used) features of the database. I used for example regular expressions to check for a valid email address in the registration page of the World Cup 2006 application."
-- Dmitri Gielis, Dmitri Gielis Blog

"[Consumers] will find the fine 'pocket references' produced by O'Reilly to be compact and affordable."
-- James Cox, The Computer Shelf: Midwest Book Review

Hide extended reviews