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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

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

Expert Solution
Step 1

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

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Header Files
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY