Errata

Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By Corrected
Printed Page 78
para. 3, line 2

"is for a blue Ghia but she does not mind which model"

now reads

"is for a blue Ghia but she does not mind which car"

(change "model" to "car")

Also, the code sample has been changed to:

SELECT cml.car_name
FROM model_color_links mcl
, car_model_links cml
WHERE mcl.model_name = cml.model_name
AND mcl.color_name = 'Blue'
AND cml.model_name = 'GL'

 Anonymous  Jan 1999
Printed Page 79
Figure 3-16 is new

Anonymous  Sep 1997
Printed Page 80
Figure 3-17: The boxes for "DEPARTMENT" and "EMPLOYMENT" have

been switched.

 Anonymous  Aug 1999
Printed Page 81
Figure 3-18: The relationship shown is reversed.

The words "mananged by" and "the manager of" have been switched.

 Anonymous  Aug 1999
Printed Page 81
in the first complete sentence (lines 1-3)

"In other words, the subtypes must be mutually exclusive, and
there cannot be any occurances of the subtype which do not
belong to a subtype."

the last word now reads "supertype" rather than "subtype"

 Anonymous  Aug 1999
Printed Page 120
2nd para. in box: changed "'ab,'" to "'ab '"

Anonymous  Sep 1997
Printed Page 127

last code example on the page now reads:

SELECT *
FROM t
WHERE NVL(:p, '$NULL') = NVL(t.a,'$NULL');

 Anonymous  Sep 1997
Printed Page 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.

 Anonymous 
Printed Page 174
line 18 of examble 1b

Line 19

IF p_from <= SYSDATE

should be:

IF p_from > SYSDATE

 Anonymous 
Printed Page 220
replaced the three bullet items with the following

* For each tablespace, always set PCTINCREASE to zero, because any
other value is liable to cause tablespace free space fragmentation.

* For each tablespace, set the values of INITIAL and NEXT equal to each
other.

* For objects within a tablespace, do not ordinarily specify the
INITIAL, NEXT, or PCTINCREASE values (allow them to be inherited from
the tablespace).

 Anonymous  Sep 1998
Printed Page 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..."

 Anonymous 
Printed Page 528
added the following to the next-to-last para.

Whenever possible, our books use RepKover (tm), a durable and flexible
lay-flat binding. If the page count exceeds RepKover's limit, perfect
binding is used.

 Anonymous  Mar 1998