<< 1 >>
Rating: 
Summary: Cool small booklet on new ORACLE 10g feature
Review: "ORACLE Regular Expressions" is a booklet about the new ORACLE 10g SQL functions that work with regular expressions:- REGEXP_INSTR
- REGEXP_LIKE
- REGEXP_REPLACE
- REGEXP_SUBSTR The authors describe the new functions and the ORACLE regular expression dialect (what kind of patterns the regexp engine handles). The book consists of five chapters: - Tutorial (an introduction into regular expressions)
- ORACLE's regular epression support (the functions, NLS support, Perl vs. ORACLE regular expressions)
- Regular Expression Quick Reference (explanation of the regexp dialect that ORACLE understands, what metacharacters does what and so on)
- ORACLE Regular Expression Functions (who to call the four functions mentioned above)
- ORACLE Regular Expression Error Messages (the new ORA- errors related to regexps) Unfortunately I had no access to an ORACLE 10g database at the time of writing this review (ORACLE 10g was not available for download the "normal" users yet), so that I was not able to test the new functions and the examples in this book (although I am looking forward to do this sooon). I think that "ORACLE Regular Expressions" is not sufficient to learn Regular Expressions from scratch but this was not the goal of this book anyway. If you are new to regular expressions, get J. Friedl's book "Mastering Regular Expressions" (the very best book about regular expressions in general). Afterwards "ORACLE Regular Expressions" will be perfect as a small reference book for the ORACLE regexp implementation. I liked the comparison between ORACLE and Perl Regexp Support (I am a big Perl fan, and did lots of DBI programs on ORACLE with Perl). Unfortunately this book is missing an example on how to create a function based index to support REGEXP_LIKE queries (the possibility was mentioned) and get no full table scan. The pocket reference book from O'Reilly does not contain an alphabetic index. However because of the good table of contents and the small size of the book, having an index is not really necessary.
Rating:
Summary: Cool small booklet on new ORACLE 10g feature
Review: "ORACLE Regular Expressions" is a booklet about the new ORACLE 10g SQL functions that work with regular expressions: - REGEXP_INSTR
- REGEXP_LIKE
- REGEXP_REPLACE
- REGEXP_SUBSTR The authors describe the new functions and the ORACLE regular expression dialect (what kind of patterns the regexp engine handles). The book consists of five chapters: - Tutorial (an introduction into regular expressions)
- ORACLE's regular epression support (the functions, NLS support, Perl vs. ORACLE regular expressions)
- Regular Expression Quick Reference (explanation of the regexp dialect that ORACLE understands, what metacharacters does what and so on)
- ORACLE Regular Expression Functions (who to call the four functions mentioned above)
- ORACLE Regular Expression Error Messages (the new ORA- errors related to regexps) Unfortunately I had no access to an ORACLE 10g database at the time of writing this review (ORACLE 10g was not available for download the "normal" users yet), so that I was not able to test the new functions and the examples in this book (although I am looking forward to do this sooon). I think that "ORACLE Regular Expressions" is not sufficient to learn Regular Expressions from scratch but this was not the goal of this book anyway. If you are new to regular expressions, get J. Friedl's book "Mastering Regular Expressions" (the very best book about regular expressions in general). Afterwards "ORACLE Regular Expressions" will be perfect as a small reference book for the ORACLE regexp implementation. I liked the comparison between ORACLE and Perl Regexp Support (I am a big Perl fan, and did lots of DBI programs on ORACLE with Perl). Unfortunately this book is missing an example on how to create a function based index to support REGEXP_LIKE queries (the possibility was mentioned) and get no full table scan. The pocket reference book from O'Reilly does not contain an alphabetic index. However because of the good table of contents and the small size of the book, having an index is not really necessary.
<< 1 >>
| 
