display_all_recors_using_explicit_cursor

PHOTO EMBED

Sun May 26 2024 17:37:19 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%notfound;
   dbms_output.put_line(e.empno||'    ' ||e.ename||'    '||e.sal);
  end loop;
end;
/
content_copyCOPY