Previous | Table of Contents | Next

Page 219

    in this application. Define all the cursor functions with the For Looping structure.
  1. Modify the application in #6 to display the tools and glasses each employee purchased. This requires two nested looping procedures in the cursor for loop.
  2. Create a function that calculates the total wages per department.
  3. Create a procedure that displays the employees of a given department. This procedure should call the function created in #8. The function should be used to determine the percentage that each employee's wages are of the department total. The procedure should list the results.
  4. Create an anonymous block that calls the procedure in #9.
  5. Create a package that contains a cursor that selects the employees from the Employee table, the function in #8, and the procedure in #9. The procedure should use the package cursor. Create anonymous blocks that call these objects.

Page 220

Previous | Table of Contents | Next