Question: Using MySQL....Please respond with the necessary statements Project 2 is about printing variables for a single record from DDI.LEDGER_VIEW using PL/SQL 1. SPOOL your output

Using MySQL....Please respond with the necessary statements

Project 2 is about printing variables for a single record from DDI.LEDGER_VIEW using PL/SQL

1. SPOOL your output to c:\CS4210\project2spool.txt

2. Set up variables in the DECLARE section. Use either %TYPE or %ROWTYPE

3. SELECT all the fields in DDI.LEDGER_VIEW where REGID is to be determined at run time.

4. Use DBMS__OUTPUT.OUTPUT_LINE to print the values for each field.

5. Compile and run the procedure for the REGID 17

Thank you

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:

Using MySQL....Please respond with the necessary statements Project 2 is about printing variables for a single record from DDI.LEDGER_VIEW using PL/SQL 1. SPOOL your output to...

Q:

Project 2 is about printing variables for a single record from DDI.LEDGER_VIEW using PL/SQL 1. SPOOL your output 2. Set up variables in the DECLARE section. Use either %TYPE or %ROWTYPE 3. SELECT all...

Q:

Script for DDI: DROP USER DDI CASCADE; CREATE USER DDI PROFILE DEFAULT IDENTIFIED BY oracle DEFAULT TABLESPACE USERS ACCOUNT UNLOCK; GRANT CONNECT TO DDI; GRANT RESOURCE TO DDI; CREATE TABLE...

Q:

Project 2: Printing variables Project 2 is about printing variables for a single record from DDI.LEDGER_VIEW using PL/SQL 1. SPOOL your output to c:\CS4210\project2spool.txt 2. Set up variables in...

Q:

Project 3: Printing multiple records 1. Project 3 is about printing multiple records from DDI.LEDGER_VIEW using a PL/SQL LOOP 2. SPOOL your output to c:\CS\project3spool.txt 3. Set up a record...

Q:

Project 3: Printing multiple records 1. Project 3 is about printing multiple records from DDI.LEDGER_VIEW using a PL/SQL LOOP 2. SPOOL your output to c:\CS\project3spool.txt 3. Set up a record...

Q:

This is the question to Project 3 1. Project 3 is about printing multiple records from DDI.LEDGER_VIEW using a PL/SQL LOOP 2. SPOOL your output to c:\CS4210\project3spool.txt 3. Set up a record...

Q:

Hi I need help with this project that I am doing. It has to be in C language and I don't what to do. This is for my Data Structure course. Please it has to be in Language of C. Programming Assignment...

Q:

Use the diagram of the sample Class File System directory tree to assist with this lab. Step 1. Open the terminal window Click Start->All Programs->PuTTY(64-bit) folder->PuTTY icon enter "ubuntu"...

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:

A U.S.-based MNC has a foreign subsidiary that earns $250,000 before local taxes, with all the after-tax funds to be available to the parent in the form of dividends. The applicable taxes consist of...

Q:

The primary goal of financial management is most associated with increasing the: a) dollar amount of each sale b) traffic flow within the firm's stores c) the fixed costs while lowering the variable...

Q:

If the percentage of ownership represents a minority interest and the corporation has an excellent dividend - paying record, a discount may be needed in the valuation of a closely held business. True...

Q:

what are the factors that shape your organization external competitiveness to recruit and retain employees

Q:

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: CREDIT SALES METHOD. Bradford ~Plumbing had the following data for a recent year. LO8 REQUIRED: 1. Compute uncollectible account expense for the year. 2....

Q:

(Appendices) EFFECTS OF SALES DISCOUNTS. Castore Security Systems makes all sales on credit, with terms 2/10, n/30. During 19x9, the list price (prediscount) of goods sold was $720,000. Customers...

Q:

(Appendices) SALES RECORDED GROSS. Nevada Company sold merchandise with a list price of $12,500 to Small Enterprises on terms 3/15, n/30. Nevada records sales net of discount. LO2 REQUIRED: 1....