declare cursor c1 is select * from employee; e employee%rowtype; begin open c1; loop fetch c1 into e; exit when c1%notfound; dbms_output.put_line(e.empno||' ' ||e.ename||' '||e.sal); end loop; end; /
declare cursor c1 is select * from employee; e employee%rowtype; begin open c1; loop fetch c1 into e; exit when c1%notfound; dbms_output.put_line(e.empno||' ' ||e.ename||' '||e.sal); end loop; end; /