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

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

Once you reply to all of the prompts and the script completes successfully, you can exit SQL*Plus by using an EXIT command.

NOTERelative to the previous chapters in this book, this chapter contains ...

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.