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.
Version |
Location |
Description |
Submitted By |
Date Submitted |
Date Corrected |
Printed |
Page xi
Section: "Conventions Used in This Book" |
italics removed from the term "UPPERCASE"
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 12
Section: "What's in Store"; 1st sentence |
special emphasis of the"
->
special emphasis on the"
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 21
Table 2-5, range for HH (hours) |
01 to 24
->
00 to 23
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 21
Table 2-5, range for MI (minutes) |
01 to 60
->
00 to 59
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 47
1st paragraph |
e.dept_id = d.dept_id
->
employee.dept_id = department.dept_id
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 50
3rd paragraph |
If you want to your result set in a particular...
->
If you want your result set in a particular...
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 58
the sentence |
...I am looking for nonterminated employees who are
either nontellers or who began working for the bank
in 2003 or later.
->
...I am looking for nonterminated employees who are
both nontellers and began working for the bank in
2003 or later.
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 59
WHERE clause at top of page |
changed to:
WHERE end_date IS NULL
AND title != 'Teller' AND start_date >= '2003-01-01'
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 77
2nd paragraph |
value of 1 in it's dept_id column...
->
value of 1 in its dept_id column...
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 83
the sentence |
The first subquery, which starts on line 3 and is given
the alias e, finds all inexperienced tellers
->
The first subquery, which starts on line 3 and is given
the alias e, finds all experienced tellers
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 83
2nd paragraph |
First, the account table is joined to the inexperienced teller subquery...
->
First, the account table is joined to the experienced teller subquery...
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 113
2nd paragraph, 2nd sentence |
The fourth comparison also 0yields,
->
The fourth comparison also yields 0,
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 116
Last paragraph, 1st sentence |
...replaced with the string 'hello' Oracle Database...
->
...replaced with the string 'hello'. Oracle Database...
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 137
Last row, under Min() |
Return
->
Returns
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 142
2nd paragraph |
Throughout the paragraph, "data.num" was used as
an argument for the aggregate functions. This was
changed to "val" instead.
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 142
Section beginning with "Generating Groups" at bottom of page |
The last paragraph (including section title) on page 142 is duplicated at the top of the next page, 143.
|
Anonymous |
|
Sep 01, 2007 |
Printed |
Page 151
2nd SELECT statement on the page |
FROM account a
->
FROM account
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 186
Paragraph continued from page 185 |
Therefore, when using outer joins (both inner and outer), make
sure you think carefully about whether to specify a left or
right outer join.
->
Therefore, when using outer joins, make sure you think
carefully about whether to specify a left or right outer join.
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 193
MySQL example, line 1 |
SELECT a.account_id, a.cust_id, b.name
->
SELECT a.account_id, a.cust_id, a.open_branch_id, b.name
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 219
1st row |
of rows larger then
->
of rows larger than
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 220
SHOW INDEX statement |
Key_name: dept_name_uidx
->
Key_name: dept_name_idx
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 230
2nd paragraph |
While neither SQL Server or Oracle Database generate an...
->
While neither SQL Server nor Oracle Database generates an...
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 244
4th paragraph, 1st sentence |
Earlier in the chapter, I showed you how write queries...
->
Earlier in the chapter, I showed you how to write queries...
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 256
app C, example 6-3, 2nd query; |
SELECT fname, name
->
SELECT fname, lname
##############################################
|
Anonymous |
|
Apr 01, 2007 |
Printed |
Page 262
5th line of solution for Exercise 9-4 |
WHERE b. branch_id = e.assigned_branch_id) branch_name
->
WHERE b.branch_id = e.assigned_branch_id) branch_name
##############################################
|
Anonymous |
|
Apr 01, 2007 |