普通游标循环和while游标循环

普通循环的步骤：begin 
打开游标->loop->提取->%notfound->打印->end loop->close

比如：

declare
cursor cur_1 is select * from dept;
v_1 dept%rowtype;
begin
  open cur_1;--打开游标
  loop
    fetch cur_1 into v_1; 
    exit when cur_1%notfound;--退出条件
    dbms_output.put_line(v_1.dname||' '||v_1.deptno||' '||v_1.loc);
    end loop;
  close cur_1;    
end;
 

while循环步骤：

open->提取->while+%found->loop->打印->提取->end loop->close 

比如：
declare
cursor cur_1 is select * from dept;
v_1 dept%rowtype;
begin
  open cur_1;--打开游标
  fetch cur_1 into v_1; --第一次
  while cur_1%found
    loop
    dbms_output.put_line(v_1.dname||' '||v_1.deptno||' '||v_1.loc);
    fetch cur_1 into v_1; 
    end loop;
  close cur_1;    
end;