plsql循环

loop循环

declare

v_ename emp.ename%type;

cursor emp_cur is select ename from emp;

begin

   open emp_cur;

   loop

      fetch emp_cur into v_ename;

      dbms_output.put_line(v_ename);

  exit when emp_cur%notfound;

  end loop;

  close emp_cur;

end;

 

while循环

declare 

v_ename emp.ename%type;

cursor emp_cur is select ename from emp;

begin

  open emp_cur;

  while emp_cur%isopen loop

    fetch emp_cur into v_ename;

    exit when emp_cur%notfound;

    dbms_output.put_line(v_ename);

  end loop;

  close emp_cur;

end;

 

for循环

declare 

v_ename emp.ename%type;

cursor emp_cur is select ename from emp;

begin

  for v_ename in emp_cur loop

    dbms_output.put_line(v_ename.ename);

  end loop;

end;