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;
/
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter