Question: Write MySQL , PL / SQL , or T - SQL procedures to accomplish the following task: a . Obtain the name and credit limit

Write MySQL

,

/

SQL

,

or T

-

SQL procedures to accomplish the following task:

.

Obtain the name and credit limit of the customer whose ID is currently stored in I

_

CUST

_

.

Place these values in the variables I

_

CUSTOMER

_

NAME and I

_

CREDIT

_

LIMIT, respectively. Output the contents of I

_

CUSTOMER

_

NAME and I

_

CREDIT

_

LIMIT.

.

Obtain the invoice date, customer ID

,

and first and last names for the invoice whose number currently is stored in I

_

INVOICE

_

NUM. Place these values in the variables I

_

INVOICE

_

DATE, I

_

CUST

_

,

and I

_

CUST

_

NAME, respectively. Output the contents of I

_

INVOICE

_

DATE, I

_

CUST

_

,

and I

_

CUST

_

NAME.

.

Add a row to the INVOICE table.

.

Change the date of the invoice whose number is stored in I

_

INVOICE

_

NUM to the date currently found in I

_

INVOICE

_

DATE.

.

Delete the invoice whose number is stored in I

_

INVOICE

_

NUM.

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!

Using SQL complete the following questions 1-4 Colonial Adventure Tours Use the Colonial Adventure Tours database (see Figures 1-4 through 1-8 in complete the following exercises. If directed t...

Write PL/SQL (or MySQL) procedures to accomplish the following task: The procedure accepts the ID of a customer stored in the input variable named I_CUST_ID and displays the name (first name...

Chapter 8 ( A Guide to SQL ) Use the KimTay Pet Supplies database only. You must use Oracle. Case Exercises: Odd numbers, pg . 2 8 4 - 2 8 5 . KimTay Pet Supplies Use the KimTay Pet Supplies database...

Database Model: KimTay The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the companys recent growth no longer...

ok it has to be in Oracle. i tried to do part A on my own but I keep getting errors below is a screenshot of what I tried. if the rest of the parts are answered even better thank you 5. Write MySQL,...

The management of KimTay Pet Supplies (a supplier of pet supplies, food, and accessories located in Cody, Wyoming) has determined that the companys recent growth no longer makes it feasible to...

5. Write PL/SQL or T-SQL procedures to accomplish the following tasks: a. Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in...

The new line character is utilized solely as the last person in each message. On association with the server, a client can possibly (I) question the situation with a client by sending the client's...

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

THE CODE I MADE IS FOR PART A IT HAS AN ERROR CAN SOMEONE EXPLAIN THE ERROR TO ME ALSO IT HAS TO BE IN ORACLE APPLICATION EXPRESS. The question is the image below delimiter // CREATE PROCEDURE...

During apoptosis, phosphatidylserine (Section 9-1C) undergoes transverse movement (flip-flop). Explain why this could help identify apoptotic cells to phagocytic cells for engulfment and disposal.

Find a general solution to the following difference equation: Yn+2-2yn+1+Yn = n

Which of the following is not a fictitious revenue scheme?

Suppose it is possible to execute covered interest arbitrage across the US and Euro zone markets because the covered rate of return from the US point of view is lower than the US rate of interest....

D What is your opinion on Gribbens new edition? Are his editorial changes sensitive and helpful, or is he sanitizing history?

Think back to where you grew upwhether in the United States or abroad. Are there any terms that you use that would cause confusion to others who speak your native tongue? Have you ever been in a...

Consider the various situations you find yourself in over the course of a given dayat home, in the classroom, at a student activity, on the job, and so on. Do you have different speech repertoires...