Code:
DECLARE
CURSOR orderlist IS
SELECT distinct inv_id, b.item_id, item_desc, inv_price
FROM inventory a, item b
WHERE a.item_id=b.item_id AND b.item_id=1
ORDER BY inv_id;
output orderlist%ROWTYPE;
error EXCEPTION;
BEGIN
OPEN orderlist;
LOOP
FETCH orderlist INTO output;
Leave a comment: