OCL1 - Fall, 2004 - Johnson
Lab 10

For each of the PL/SQL exercises, you should submit your script files (named lab8-2def.sql and lab8-2demo.sql, etc.) to Myo, who will make comments, suggestions, and corrections.

  1. Probably still have lots of exercises from last time.
  2. Produce an XML representation of the employee IDs, names, and salaries. The root node, employees, should contain employee nodes, which each contain three nodes for the fields.
  3. Download your favorite XML file and import it into an Orcle table.
  4. If you have extra time (!), you can work on these.
mattpj at gmail.com