Assignment 5, Fall 2011
=======================

Write 2 queries:

Both use cursor and looping.  Both display header info, plus details (from cursor).

1. flight initerary, given customer number and reservation number.

2. any other query from your airline reservation schema, using cursor and looping.

Upload to BlackBoard:  a ZIP file containing the 2 queries and the 2 associated spooled output files.

The script PLSQL_classes is an example of PL/SQL with cursor and looping.
You may refer to this script as a guideline for constructing your scripts.

Be sure you spool the output.  Either include the SPOOL commands as shown in the PLSQL_classes.sql example, or manually turn spooling on and off, such as:

SQL>spool intinerary_output.txt
SQL>@itinerary.sql
(query runs...)
SQL>spool off
SQL>exit