given the following 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)$

$)$;

$2)$

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 fill all rows with the first input : DECLARE

v$\_$price items.price$\%$type;

v$\_$quantity items.quantity$\%$type;

v$\_$amount items.amount$\%$type;

v$\_$q$\_$r$\_$status items.q$\_$r$\_$status$\%$type;

CURSOR allitems is

SELECT $*$ FROM items;

BEGIN

FOR item IN allitems 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

WHERE itemid $=$ item.itemid;

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

WHERE itemid $=$ item.itemid;

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;

$/$