CS4210 Project 5-Printing Multiple Records II Points: 60

SPOOL your output to c:\cs4210\project7spool.txt

1. DECLARE a record variable, a variable to keep track of a change in RoomNum, and two accumulators

2. Add procedures to the Print multiple records

3. In the BEGIN block add a select statement to read all the ledger records in DDI.LEDGER_VIEW ordered by RoomNum and RegDate

4. Add a LOOP

5. Use DBMS__OUTPUT.PUT statements to print all the values for each record on a single line. End with a DBMS_OUTPUT.NEW_LINE

6. After the LOOP be sure to print the final subtotal and the grand total

7. Compile and run the procedure

Submit your spool output file (Project5spool.txt) click on the Submit Assignment button.