Question: Write a PL/SQL code: write an anonymous block program unit that takes as user-input vendor_id and prints the average invoice_total for that specific vendor_id. The

Write a PL/SQL code:

write an anonymous block program unit that takes as user-input vendor_id and prints the average invoice_total for that specific vendor_id. The program raises an exception if the average invoice_total for that vendor_id is greater than or equal 1900 and print the message 'High Invoice_due'

Try two test cases:

Input: 117

Input: 122

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!

Write a PL/SQL code: write an anonymous block program unit that inserts a user-input value into employees table and prints a message 'record is inserted successfully' as following: Employee_id:...

PL/SQL write an anonymous block program unit that takes as user-input vendor_id and prints the average invoice_total for that specific vendor_id. The program raises an exception if the average...

write an anonymous PL/SQL block program unit that delete the invoices that are due after a user-input date and print a message 'invoices have been deleted successfully'. The program raises an...

Write an PL/SQL anonymous block program unit that display the number of invoices in invoices table for a specific state which is input by the user (bind variable). The number of invoices should be...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

1. Introduction to Computer Architecture concepts; The MIPS R2000 architecture allows for up to four external coprocessors. Our local systems arIPS external coprocessors are used by describing, in...

This question involves the use of AGGREGATE linear PYTHOIN regression on the Auto data set. (a) Perform a simple linear regression with mpg as the response and horsepower as the predictor. Describe...

Question 1 Morality is Select one: A. Universal and basic to human relationships. B. Established by the common law. C. The system that protects property and people. D. The application of ethics to...

123 Compare the purely graphical properties of these two notations, and the ways in which the graphical properties of each display correspond to the information structure being defined. Describe...

I need help with this assignment. See the instruction below and please please can you do full inline comment and document for everything you do too. Programming Assignment 3: UDP Pinger Lab In this...

Let X1, . . . , Xn be a large random sample from a distribution with p.d.f. f . Assume that f is symmetric about the median of the distribution. Find the large-sample distribution of the sample IQR.

Explain what operational requirements any business would need to incorporate immediately upon entering the environment of cloud computing, including any legal requirements that would be placed upon...

9.25 The manager of a falafel store in Lebanon claims that the waiting time of his customers in placing orders and collecting them is 5 minutes. To justify his claim, he selects a random sample of 50...

Discuss several ways ( at least four ways ) to improve the requirement process and thus, a project team can avoid a situation where too many changes to the project requirements occur at the later...

Each chapter/section should include: a Introduction and summary. b A separate list of references. c An overview of the case study organisation(s). d Charts and graphs.

The justification for your sampling strategy should be outlined in: a Introduction. b Literature review. c Methodology. d Conclusions.

Do you need to make your manager (and other stakeholders) aware of your forthcoming deadline? Do you need to request any specific support?