Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started