Learning Goal: I’m working on a mysql question and need the explanation and answer to help me learn.
What would the spool output look like for this (have attached coressponding document):
SPOOL output
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