Chapter Prerequisites

To practice the hands-on exercises in this chapter, you need to start SQL*Plus as instructed in Exercise 2.11 and run the following command script:

location\handsonxe\sql\chap10.sql

where location is the file directory where you expanded the support archive that accompanies this book. For example, after starting SQL*Plus, you can run this chapter's SQL command script using the SQL*Plus command @, as in the following example (assuming that your chap10.sql file is in C:\temp\handsonxe\sql):

SQL> @C:\temp\handsonxe\sql\chap10.sql;

Be aware that this chapter's support script generates a lot of data. Do not be alarmed while the script takes a few minutes to complete. Additionally, make a note of the time of day that you execute ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.