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