display_5_records_using_explicit_cursor

PHOTO EMBED

Sun May 26 2024 17:41:25 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

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;
/
content_copyCOPY