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 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
Get step-by-step solutions from verified subject matter experts
