Brewbeans has suspicions that there is an error


Brewbeans has suspicions that there is an error with some data in the bb_basket table. They suspect that the total column is not really the sum of the three columns subtotal, shipping, and tax (as it should be). They have asked you to write a PL/SQL block that displays the idbasket of each row where the arithmetic is incorrect. Below is the start of that PL/SQL block. The CURSOR is defined, and the CURSOR FOR LOOP exists in the body of the block. Your job is to fill in between the FOR LOOP and the END LOOP so that the block displays the idbasket of each row where the arithmetic is incorrect.

SET SERVEROUTPUT ON
DECLARE
CURSOR cur_basket IS
SELECT idbasket, total, subtotal, shipping, tax
FROM bb_basket
WHERE orderplaced = 1;

lv_total bb_basket.total%TYPE;
BEGIN
FOR rec_basket IN cur_basket LOOP

END LOOP;
END; 

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Brewbeans has suspicions that there is an error
Reference No:- TGS0109890

Expected delivery within 24 Hours