SQL Database Programming

Project 5-Printing Multiple Records II

SPOOL your output to c:\cs\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