Oracle Design
by Dave Ensor and Ian Stevenson



This errata page lists errors outstanding in the most recent printing, 8/99.  

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


This page was last modified on June 28, 2000.


Here's the 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:


{167} There are several errors in the function:

Line 2:     The table is called 'prices' not 'price'.
Line 4:     Should read 'RETURN' not 'RETURNS'.
Line 13/14: The NVL function should be applied to date_to not p_when.
            Missing Right Parenthesis after NVL.

Note that the downloadable version has even more errors in it, such as
inequalities reversed.

The format of all the to_date function calls should be

  TO_DATE( argument1 , argument2)

thus on p174 (which has the same line 2 error as p167) the function should
be

  TO_DATE('1-Dec-4712','DD-Mon-YYYY');

To be pedantic, the semicolon is not part of the function call but is the
statement delimiter.

This problem can be observed on pages 170, 171, 174 and 175.


[174]  line 18 of examble 1b;
Line 19

IF p_from <= SYSDATE

should be:

IF p_from > SYSDATE


{222}  In the fourth paragraph, the text states:

        "If PCTFREE and PCTFREE are too close together..."

Should be "If PCTFREE and PCTUSED are too close together..."