CS444 - MP 10

Fun with Cursors

The Problem

In this MP you will use PL/SQL and some SQL table generation commands (located here) to do some cursor manipulations.

The SQL file creates the following tables:

  1. students
  2. major_stats (table not populated)
  3. rooms
  4. classes
  5. registered_students
  6. RS_audit (not populated)
  7. log_table (not populated initially, but used for messages)
  8. temp_table (not populated)
  9. debug_table (not populated)
  10. exception_table (not populated)
  11. source
  12. destination

Your task is to use cursor control as in Example 4 in Handout 11 (using FETCH into PL/SQL %ROWTYPE record based on the TABLE row type) to output the values from the rooms and classes tables.

What to Turn In

A listing of the PL/SQL statements used to obtain the requested information. Also include a listing of the output.

All assignments must be submitted to the online homework submission system. Put the information you captured in a file called mp10.txt. Make sure the file is readable with Notepad. Submit the file mp10.txt to the online homework submission system.