Click on the Examples link to go to the book’s web companion. You will also find information about all of Steven’s books and accompanying resources at:
As mentioned earlier, you will also find the contents of some of the chapters from earlier editions that we removed or condensed in the different editions of the book. These may be especially helpful to readers who are running older versions of Oracle.
You might also want to visit PL/SQL Obsession (Steven Feuerstein’s PL/SQL portal) at:
where you will find training materials, code downloads, and more.
To find a particular example on the book’s web site, look for the filename cited in the text. For many examples, you will find filenames in the following form provided as a comment at the beginning of the example shown in the book, as illustrated here:
/* File on web: fullname.pkg */
If the code snippet in which you are interested does not have a “File on web” comment, then you should check the corresponding chapter code file.
A chapter code file contains all the code fragments and examples that do not merit their own file, but may prove useful to you for copy-and-paste operations. These files also contain the DDL statements to create tables and other objects on which the code may depend.
Each chapter code file is named chNN_code.sql, where NN is the number of the chapter.
Finally, the hr_schema_install.sql script will create the standard Oracle Human Resources demonstration tables, such as employees and departments. These tables are used in examples throughout the book.