Print formatted records (what should spool output look like) 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
Print formatted records (what should spool output look like)
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
DBMS stands for Database management system. In DBMS we can craete and maage our recods in database. For using the database we can use any language llike sql. we have to Print formatted records by using 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'
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
