ORACLE SQL BY EXAMPLE BY ALICE RISCHERT
  • Download the Sample Database
  • Answers to Workshop Exercises
  • Resources and Links
  • Errata
  • About the Book
  • Download the Sample Database
  • Answers to Workshop Exercises
  • Resources and Links
  • Errata
  • About the Book

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
[email protected]
​
Proudly powered by Weebly