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\chap05.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 chap05.sql file is in C:\temp\handsonxe\sql):

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

Once you reply to all of the prompts and the script completes successfully, leave the current SQL*Plus session open—you'll need it later on in several of this chapter's exercises.

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.