TEC 5323 Advanced Database Technology

Download for Support Files
for Hands-On Exercises in the Course

 

All subsequent chapters in this course contain hands-on exercises that provide you with invaluable experience using Oracle database. At the beginning of most chapters, a section called "Chapter Prerequisites" explains the steps necessary to prepare for the chapter's exercises. Typically, you'll be asked to use Oracle's SQL*Plus utility to run a SQL command script that builds a practice schema for the chapter, complete with a set of tables and other supporting database objects. Most scripts also set up custom display formats for the SQL*Plus session, so that the results produced by the chapter's exercises are easy to read.

You will need to download and then use the support files starting from chapter 4. I suggest that you review the instructions below before downloading.

  

Download the archive to a temporary directory on your computer—for example, C:\Temp. Next, use Windows Explorer to locate the file and execute it (double-clicking the file should work). The file will extract itself and create the following directory structure, assuming that you downloaded the file in C:\Temp and expanded it from the same directory.

 

The Doc directory contains a single file, readme.txt, that contains the latest information about the support files for this book. The Java directory contains several Java source files that support the exercises in Chapter 6. The Sql directory contains several SQL command scripts, named by chapter number, that support the corresponding chapters in this book.

When you start a new chapter, follow the directions in the "Chapter Prerequisites" section to prepare for the chapter's exercises. Also note that certain exercises in the book contain additional instructions for using specific support files.

 

CAUTION

 

Unless otherwise indicated, after you successfully run a chapter's supporting SQL command script using SQL*Plus, do not exit the SQL*Plus session. You should use the SQL *Plus session to complete the exercises in the chapter, starting with the first exercise in the chapter, all the way through the final exercise in the chapter. If you do not have time to complete all exercises in the chapter during one sitting, leave your computer running and the SQL*Plus session open so that you can pick up where you left off when you have more time. If you must shut down your computer, the next time that you start SQL*Plus you must rerun the chapter's SQL command script (to refresh the necessary data and SQL*Plus display settings) and then repeat all exercises in the chapter, starting with the first exercise again.

When you are ready, click here to download.

 

Go Back to Course Index

 

School of Technology
College of Business & Applied Sciences
Eastern Illinois University