What's on the CD

What's on the CD

The following sections provide a summary of the software and other materials you'll find on the CD.

Author-created materials

All author-created material from the book, including code listings and samples, are on the CD in the folder named "sqlbib." The CD also contains complete authors' SQL scripts and examples used in the book, with different versions for Oracle 9i, IBM DB2 UDB 8.1, and Microsoft SQL Server 2000.

Please run the specific version for the RDBMS of your choice as from the respective directories: /sqlbib/acme_oracle/, /sqlbib/acme_db2/, and /sqlbib/acme_mssql/.

The following files are supplied for you to create and populate the sample ACME database:

  •  create_acme_ora.sql: creates database and all database objects for Oracle 9i

  • load_data_oradat: populates the ACME database with the appropriate data for Oracle 9i

  •  load.sql: runs create_acme_oracle.sql and then load_data_oracle.sql

  •  create_acme_db2.sql: creates database and all database objects for IBM DB2 UDB 8.1

  •  load_data_db2.dat: populates the ACME database with the appropriate data for IBM DB2 UDB 8.1

  •  create_acme_mssql.sql: creates database and all database objects for Microsoft SQL Server 2000

  •  load_data_mssql.dat: populates the ACME database with the appropriate data for Microsoft SQL Server 2000

  •  triggers_ora.sql,  triggers_db2.sql, and  triggers_mssql.sql demonstrate topics discussed in Chapter 16

  •  empty_acme.sql (found in the vendor-specific directories): creates empty schema for Oracle 9i and an empty database for MS SQL Server 2000 (required for examples in Chapters 3, 4, 5, and 6)

The use of these files is described in Appendixes D, E, and F, as well as in chapters where they are mentioned. Examples in Chapters 3 through 6 assume an empty ACME database created with  empty_acme.sql. The rest of the chapters rely on the database structures installed as described in Appendix F.


The following applications are on your CD:

  • IBM DB2 Universal Database Personal Edition Version 8.1 for Microsoft Windows Operating Environments Evaluation Copy (Windows NT/2000/XP). It provides a single-user database engine for deployment to PC-based users. The PE includes the ability to be remotely managed, which makes it the perfect choice for deployment in occasionally connected or remote office implementations that don't require multi-user capability. Detailed installation instructions are provided in Appendix D.

Note: This is a time-limited version of DB2 and will expire and become unoperational on or about November 30, 2004.

  • Adobe Acrobat Reader free software for viewing and printing Adobe Portable Document Format (PDF) files on all major hardware and operating system platforms.

Shareware programs are fully functional, trial versions of copyrighted programs. If you like particular programs, register with their authors for a nominal fee and receive licenses, enhanced versions, and technical support. Freeware programs are copyrighted games, applications, and utilities that are free for personal use. Unlike shareware, these programs do not require a fee or provide technical support. GNU software is governed by its own license, which is included inside the folder of the GNU product. See the GNU license for more details.

Trial, demo, or evaluation versions are usually limited either by time or functionality (such as being unable to save projects). Some trial versions are very sensitive to system date changes. If you alter your computer's date, the programs will "time out" and will no longer be functional.

eBook version of SQL Bible

The complete text of this book is provided in Adobe's Portable Document Format (PDF). It does not include the scripts required to create sample database. You can read and search through the file with the Adobe Acrobat Reader (also provided).