Setup Instructions for Chapter 8
Database Setup
Before running the examples in Chapter 8, do the following:
- Set your current directory to ./orxmlapp/Examples/ch08
- Run the following SQL scripts as the indicated user...
- As user XMLBOOK, run the create_ch8_tables.sql script.
Creates all the various tables and types used by the examples
- As user XMLBOOK, run the PatientVisitFacilityDoctor.sql script.
Creates the patient, visit, doctor, and facility tables used here and
in Chapter 10
- As user XMLBOOK, run the CreateAirports.sql script.
Creates the airport table listing all of the worlds airport names used
here and in chapter 11
To run a script use the SQL*Plus command-line tool that
comes with your Oracle database using the command:
$ sqlplus username/password @scriptname.sql