Print multiple formatted records (what should spool file look like?)show detailed code

SPOOL your output to c:\Folder\project5spool.txt

Set SERVEROUTPUT ON to use the DBMS_OUTPUT package

Declare variables for the entire record using %ROWTYPE

Use FOR/IN to read all records from DDI.LEDGER_VIEW

The SELECT statement should read all fields from DDI.LEDGER_VIEW

where REGDATE = '01-JUN-15' ordered by ROOMNUM

Use DBMS__OUTPUT.OUTPUT_LINE to print the values for each field concatenate FIRSTNAME and LASTNAME into a single name and use" TO_CHAR to format dates as 'MM/DD/YYYY' and currency as '999,999.00'

Compile and run the procedure

Close spool