Using MySQL

Project 4 is about printing a formatted report from DDI.LEDGER_VIEW using Head of Forms, Form Breaks, and an End of Form.

1. SPOOL your output to c:\CS4210\project4spool.txt

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

3. Add procedures to the DECLARE block to print a Head of Form, subtotals, and a grand total

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

5. Add a LOOP

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

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

8. Compile and run the procedure