Question
Using MySQL SPOOL your output to c:cs4210project7spool.txt 1. DECLARE a record variable, a variable to keep track of a change in RoomNum, and two accumulators
Using MySQL
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started