Oracle SQL by Example 

 

Book Updates and Errata

 

Page 18

Figure 1.15 has the incorrect colum heading for the AUTHOR table.  It should read “LAST_NAME” instead of “TITLE” and “FIRST_NAME” instead of “RETAIL_PRICE”.

 

Figure 1.16 has the incorrect colum heading for the AUTHOR table.  It should read “LAST_NAME” instead of “TITLE”.

 

 

Page 275

The HAVING clause in the SQL statement below the heading “The HAVING Clause” contains the extraneous characters “j277”.  The clause should read:

HAVING SUM(CAPACITY) > 50

 

 

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@yahoo.com