Errata

Mastering Oracle SQL

Errata for Mastering Oracle SQL

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page xiii
3

This page suggests the examples (and the schema plus sample data) might be available
for download.

However I do not see a download link on the site and page.

 Anonymous   
Printed Page 5
Diagram of the Database

There is a relationship shown between the Customer table and the Part table. This
relationship should not be there. There is no relationship shown between the
Cust_Order table and the Line_Item table. There should be a relationship here.

 Anonymous   
Printed Page 34
the 5th line from top

An outer join condition containing the OR operator may not .....
^^
|
should be (+) <-------------------------

 Anonymous   
Printed Page 71

you say "While everyone except the lowest paid employee has a salary >= some ...",
this statement isn't true. Actually, everyone will have a salary >= some,
because the lowest paid employee's salary is equal to his/her salary.

 Anonymous   
Printed Page 171
Last paragraph, second line

The last word should be "from," not "then."

 Anonymous   
Printed Page 286
code example, line 6

The line 6 should read "ORDER BY month;"

 Anonymous   
Printed Page 300

you say

"We discussed UNION and UNION all in Chapter 6."

actually the chapter on unions and set operations is chapter 7 and not 6.

 Anonymous