Oracle Regular Expressions Pocket Reference
by Jonathan Gennick, Peter Linsley

This errata page lists errors outstanding in the most recent printing.

If you have technical questions or error reports, you can send them to
booktech@oreilly.com.  Please specify the printing date of your copy.

This page was updated March 9, 2004.

Here's a key to the markup:
	[page-number]: serious technical mistake
	{page-number}: minor technical mistake
	<page-number>: important language/formatting problem
	(page-number): language change or minor formatting problem
	?page-number?: reader question or request for clarification



Confirmed errors:

page 3: In the last para, the URL forthe book is:
http://oreilly.com/catalog/oracleregex
It should be
http://www.oreilly.com/catalog/oracleregexpr


(36)  2nd Paragraph;
The first sentence of paragraph two reads as follows:

    The following example uses the collation element [.ch.]
    to find a word containing the Spanish letter 'ch'...

The example, in fact, shows the incorrect results that you get when you fail to use a
collation element. The sentence should read:

    The following example uses the bracket-expression [ch]
    in an attempt to find a word containing the Spanish
    letter 'ch'...


  The two code examples;
This errata doesn't concern a mistake, but rather a point that I realize now might
cause some small amount of confusion. You'll find two code examples on page 36. One
begins with SET NLS_LANGUAGE=SPANISH, the other with SET NLS_SORT=XSPANISH. You might
wonder why I set NLS_LANGUAGE the first time, while setting NLS_SORT the next.

The NLS_LANGUAGE parameter is a sort of "umbrella parameter" that drives the values
of a number of language related parameters. If you're going to work with Spanish
text, it makes sense to set NLS_LANGUAGE=SPANISH, as that in turn sets NLS_SORT,
NLS_DATE_FORMAT, and other such parameters to appropriate defaults for the language.
By setting NLS_LANGUAGE=SPANISH, I was, in effect, also setting NLS_SORT=SPANISH.

There are two sorts (maybe more) defined for the Spanish language. For the second
example, I needed the XSPANISH sort, which isn't the default. Thus, I needed to be
more specific, and set NLS_SORT directly. If you're working with Spanish text, and
wish to use the XSPANISH sort, you should usually first set NLS_LANGUAGE=SPANISH, and
then set NLS_SORT=XSPANISH.


page 49:
In first para, the phrase
see "Regular Expression Matching Options" in the "Tutorial" section
should be
see "Regular Expression Matching Options" in the "Oracle's Regular Expression Support" section


page 54:
in the first para, same edit needed as above, the phrase
see "Regular Expression Matching Options" in the "Tutorial" section
should be
see "Regular Expression Matching Options" in the "Oracle's Regular Expression Support" section