Oracle Design: The Definitive Guide

Errata for Oracle Design: The Definitive Guide

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 "Date 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 Note Update



Version Location Description Submitted By Date Submitted Date 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 01, 1999
Printed
Page 79
Figure 3-16 is new

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

been switched.

Anonymous    Aug 01, 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 01, 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 01, 1999
Printed
Page 120
2nd para. in box: changed "'ab,'" to "'ab '"

Anonymous    Sep 01, 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 01, 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 01, 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 01, 1998