DECLARE CURSOR stock_cur IS SELECT c.address,c.salary FROM customers c; stock_rec stock_cur%rowtype; BEGIN IF NOT stock_cur%ISOPEN THEN OPEN stock_cur; END IF; LOOP FETCH stock_cur INTO stock_rec; EXIT WHEN stock_cur%NOTFOUND; dbms_output.put_line('Address ' || stock_rec.address || ' - Current Salary : ' || stock_rec.salary); END LOOP; CLOSE stock_cur; END;