Oracle PL/SQL cursor(游标)

创建简单游标:

declare
 cursor c is select * from emp;
 v_emp c%rowtype;
begin
 open c;
 fetch c into v_emp;
 dbms_output.put_line(v_emp.ename);
 close c;
end;

使用LOOP循环遍历游标:

declare
 cursor c is select * from emp;
 v_emp c%rowtype;
begin
 open c;
  loop
   fetch c into v_emp;
    exit when (c%notfound);
    dbms_output.put_line(v_emp.ename);
  end loop;
 close c;
end;

使用While循环遍历游标:

 declare
  cursor c is select * from emp;
  v_emp c%rowtype;
 begin
  open c;
   fetch c into v_emp;
   while(c%found) loop
    dbms_output.put_line(v_emp.ename);
    fetch c into v_emp;
   end loop;
  close c;
 end;

使用For循环遍历游标:

 declare
  cursor c is select * from emp;
 begin
   for v_emp in c loop
     dbms_output.put_line(v_emp.ename);
   end loop;
 end;