oreilly.com -- Online Catalog: Oracle Regular Expressions Pocket Reference

Buy Print Book:
$9.95 USD

Buy PDF:
$4.99 USD

Buy Print Book:
£6.95 GBP

What is this?

Read it online

Read this book online
at the Safari Bookshelf.

What is Safari?

Tell a friend

Oracle Regular Expressions Pocket Reference

By Jonathan Gennick, Peter Linsley
First Edition September 2003
Pages: 64 (More details)
(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

No time right now?

Email these links Customers who bought this book also bought:

Oracle Utilities Pocket Reference Read more	Oracle SQL Tuning Pocket Reference Read more	Oracle Initialization Parameters Pocket Reference Read more
Oracle PL/SQL Language Pocket Reference A guide to Oracle's PL/SQL language fundamentals Read more	Oracle Data Dictionary Pocket Reference Read more

No time right now?

Email these links Customers interested in this book may also be interested in:

Book: Oracle PL/SQL Programming Read more	Book: Oracle PL/SQL Language Pocket Reference A guide to Oracle's PL/SQL language fundamentals Read more	Book: Oracle Data Dictionary Pocket Reference Read more
Book: Oracle in a Nutshell A Desktop Quick Reference Read more

Book details

Title: Oracle Regular Expressions Pocket Reference
First Edition: September 2003
Series: Pocket References
ISBN 10: 0-596-00601-2
ISBN 13: 9780596006013
Pages: 64
Average Customer Reviews: (Based on 1 Reviews)

Featured customer reviews

Oracle Regular Expressions Pocket Reference Review Rating:
2003-09-29 06:06:11 Srinivas [Reply | 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

Read all reviews