طرق استخراج البيانات من الـ Cursor

------------------------------------[ Fetch ]--------------------------------------------
declare
 cursor c is
   select v.empno, v.ename, v.sal from emp_view v;
 eno   emp_view.empno%type;
 ename emp_view.ename%type;
 esal  emp_view.sal%type;
begin open c;
 loop
   fetch c
     into eno, ename, esal;
   exit when c%notfound;
   dbms_output.put_line(eno || ' - ' || ename || ' - ' || esal);
 end loop;
 close c;
end;


/*----------[ OutPut ]------------
1232 - MAHMOOD - 7844 
1233 - mas3ood - 43444 
1239 - AKRAM - 4400 
*/

-----------------------------------------------[ For Loop ]-----------------------------------------------
declare
 cursor c is
   select v.empno, v.ename, v.sal from emp_view v;
begin for r in c loop
   dbms_output.put_line(r.empno || ' - ' || r.ename || ' - ' || r.sal);
 end loop;
end;


/*----------[ OutPut ]------------
1232 - MAHMOOD - 7844 
1233 - mas3ood - 43444 
1239 - AKRAM - 4400 
*/

Cursor_ways.txt