Previous | Table of Contents | Next
Page
219
in this application. Define all the cursor functions with the
For Looping structure.
- 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.
- Create a function that calculates the total wages per department.
- 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.
- Create an anonymous block that calls the procedure in #9.
- 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
|