given this code: CREATE TABLE items $($

itemid NUMBER$(4)$ CONSTRAINT items$\_$pk PRIMARY KEY,

itemname VARCHAR$2(15),$

price NUMBER,

quantity NUMBER,

amount NUMBER,

q$\_$r$\_$status VARCHAR$2(15)$

$)$;

INSERT INTO items $($itemid$,$ itemname$)$ VALUES $(111,\text{'}$A$\text{'})$;

INSERT INTO items $($itemid$,$ itemname$)$ VALUES $(222,\text{'}$B$\text{'})$;

INSERT INTO items $($itemid$,$ itemname$)$ VALUES $(333,\text{'}$C$\text{'})$;

INSERT INTO items $($itemid$,$ itemname$)$ VALUES $(444,\text{'}$D$\text{'})$;

INSERT INTO items $($itemid$,$ itemname$)$ VALUES $(555,\text{'}$E$\text{'})$; why does this code put the same values in all rows : DECLARE

v$\_$price NUMBER;

v$\_$quantity NUMBER;

v$\_$amount NUMBER;

v$\_$q$\_$r$\_$status VARCHAR$2(1)$;

BEGIN

FOR item IN $($SELECT itemid FROM items$)$ LOOP

DBMS$\_$OUTPUT.PUT$(\text{'}$Enter price for item $\text{'}||$ item.itemid $||\text{'}$: $\text{'})$;

v$\_$price:$=$&v$\_$price;

DBMS$\_$OUTPUT.PUT$(\text{'}$Enter quantity for item $\text{'}||$ item.itemid $||\text{'}$: $\text{'})$;

v$\_$quantity:$=$&v$\_$quantity;

v$\_$amount :$=$ v$\_$price $*$ v$\_$quantity;

UPDATE items

SET price $=$ v$\_$price,

quantity $=$ v$\_$quantity,

amount $=$ v$\_$amount;

IF v$\_$quantity $<50$ THEN

v$\_$q$\_$r$\_$status :$=\text{'}$C$\text{'}$;

ELSIF v$\_$quantity BETWEEN $50$ AND $100$ THEN

v$\_$q$\_$r$\_$status :$=\text{'}$B$\text{'}$;

ELSE

v$\_$q$\_$r$\_$status :$=\text{'}$A$\text{'}$;

END IF;

UPDATE items

SET q$\_$r$\_$status $=$ v$\_$q$\_$r$\_$status;

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Item $\text{'}||$ item.itemid $||\text{'}-$ Price: $\text{'}||$ v$\_$price $||\text{'},$ Quantity: $\text{'}||$ v$\_$quantity $||\text{'},$ Amount: $\text{'}||$ v$\_$amount $||\text{'},$ Q$/$R Status: $\text{'}||$ v$\_$q$\_$r$\_$status$)$;

END LOOP;

END;

$/$