Question: Using MySQL SPOOL your output to c:cs4210project7spool.txt 1. DECLARE a record variable, a variable to keep track of a change in RoomNum, and two accumulators

Using MySQL

SPOOL your output to c:\cs4210\project7spool.txt

1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The following are the financial statements for Nailsea plc for the years ended 30 June 2009 and 2010: There were no disposals of non-current assets in either year. Dividends were paid in 2009 and...

Q:

CS4210 Project 5-Printing Multiple Records II Points: 60 SPOOL your output to c:\cs4210\project7spool.txt 1. DECLARE a record variable, a variable to keep track of a change in RoomNum , and two...

Q:

SQL Database Programming Project 5-Printing Multiple Records II SPOOL your output to c:\cs\project7spool.txt 1. DECLARE a record variable, a variable to keep track of a change in RoomNum, and two...

Q:

Written Assignment-Printing Report from Table Set echo on SET SERVEROUT ON Set up a spool file to receive your output for submission. I would suggest c:\CS\wa6spool.txt DECLARE a record variable, a...

Q:

Written Assignment-Printing Report from Table Points: 45 Set echo on SET SERVEROUT ON Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa6spool.txt DECLARE a...

Q:

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...

Q:

Using MySQL Project 4 is about printing a formatted report from DDI.LEDGER_VIEW using Head of Forms, Form Breaks, and an End of Form. 1. SPOOL your output to c:\CS4210\project4spool.txt 2. DECLARE a...

Q:

I could use some help on this assignment. This is in Oracle using SQL Plus. SPOOL your output to a text file DECLARE a record variable, a variable to keep track of a change in RoomNum, and two...

Q:

SPOOL your output to c:\cs422a\project5spool.txt DECLARE a record variable, a variable to keep track of a change in RoomNum, and two accumulators Add procedures to the DECLARE block to print a Head...

Q:

Using MySQL... Set echo on SET SERVEROUT ON Set up a spool file to receive your output for submission. I would suggest c:\CS4210\wa6spool.txt DECLARE a record variable, a variable to keep track of a...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

Berkshire Hathaway, the Omaha company run by Warren Buffett, owns 13.0% of the stock of American Express Company. In 2011, American Express reported a net income of $4,935 million and declared cash...

Q:

Explain why a translocation cross occurs during metaphase of meiosis I when a cell contains a reciprocal translocation.

Q:

Interpret the current ratio.(Select the best choice below.) A. The ratio tells Ojai and Kaya that their monetary assets could pay their current expenses 3.60 times. This ratio is accurate since it...

Q:

Additional Information Required: ( 1 ) Prepare a statement of cash flows using the indirect method for the year ended June 3 0 , 2 0 2 1 . Note: Amounts to be deducted should be indicated with a...

Q:

6. Go to www.eldercare.gov, the Eldercare Locator, a public service of the U.S. Administration on Aging. What resources are available on this Web site? What topics do these resources cover?

Q:

3. Are certain kinds or types of jobs better for job sharing? Do the characteristics of the job, the manager, or the employees sharing the job have the most important influence on the effectiveness...

Q:

1. From a careers perspective, why would two employees decide to job share?