Question: Write a PL/SQL script to calculate the maximum invoice total, the minimum invoice total, the percent difference between the maximum and minimum, and the number

 Write a PL/SQL script to calculate the maximum invoice total, the

Write a PL/SQL script to calculate the maximum invoice total, the minimum invoice total, the percent difference between the maximum and minimum, and the number of invoices for vendor 95. Create these variables in the DECLARE section: max invoice total -use %type to use same datatype used in the invoice total from the invoices table. min-invoice total-use %type to use same datatype used in the invoice total from the invoices table. percent difference NUMBER; count invoice id NUMBER: vendor-id-var NUMBER :=95; In BEGIN: Select appropriate values into declared variables Perform calculations Create output line for each variable in DECLARE section. Copy and Paste code and output

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!