Question: 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
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
Get step-by-step solutions from verified subject matter experts
