Updates
Below you will find updates to the book and to the Web site. If you have any comments or suggestions, or if you think you have found an error, please feel free to e-mail me.
Alice Rischert
ar280@columbia.edu
Book Updates and Errata
- Page 107. Question 2.4.1 d) The letter 'r' is missing from the column course_no in the SELECT statement.
- Page 112. Answer 2.4.2 b) The query result should be 1195 instead of 1595. The correct query result should look like this:
COST
---------
1195
1 row selected.
- Page 161. Replace the references to NULLIF with NVL instead. It will read then as:
The above result can be achieved with the NVL function.
SELECT instructor_id, zip,
NVL(zip, 'NO zipcode!') "NVL Use"
FROM instructor
WHERE instructor_id IN (102, 110)
- Page 271. The last sentence of the first paragraph indicates the incorrect number of rows. It should be 50 instead of 75. Therefore, the paragaph should read "a total capacity of greater than 50 are returned in the result."
- Page 638. Add the letter 'S' to the REFERENCES privilege in Table 14.2.
- Page 850. Add the entry "SP2-0864 462" to the index.
