Oracle PLSQL Demo

declare
    cursor cur_emp is
        select t.* from scott.emp t;

begin

     for r_emp in cur_emp loop
         
         dbms_output.put_line(r_emp.empno || '   ' || r_emp.sal);
     
     end loop;

end;