Teach Yourself PL/SQL in 21 Days, Second Edition
Frequently Asked Questions
Where can I go to download the source code for the examples in the
book?
The source code for the examples is available from Sams Publishing's catalog
page for the book. Look on the "Downloads" tab. You want the file plsqlcode.exe,
which is labeled "Source Code from the book." That file is a
self-extracting executable.
Where is Appendix B?
Chapter 6 twice refers to a SQL function reference in Appendix B. The
publisher pulled that appendix from the book at the last minute because
the page count was too high. Unfortunately, because it was a last minute
change, no one noticed the references in chapter 6, and those references made it into
the printed book. Appendix B was in fact written (by Tom Luers). It's
posted on SAMS Publishing's web site, on the catalog
page for the book. Look under "Downloads" for "Additional
Electronic Chapters." You want the self-extracting executable named
pssql.exe.
What is this EMPLOYEE table referenced in Listing 7.1?
Several listings in Chapter 7, including Listing 7.1, reference a database
table named EMPLOYEE. Unfortunately, we don't tell you how to create that
table until Chapter 8. That's our (Tom Luers' and mine) oversite, and
we apologize for it. Look in Chapter 8, at the bottom of Page 224, and
you'll find the CREATE TABLE statement for the EMPLOYEE table. Create
the table in your schema, and you will be able to execute the examples
in Chapter 7.