Question

请问存储过程中LOOP怎么跳出本次循环继续下次循环?

请问ORACLE 11g的存储过程中带游标的loop怎么跳出本次循环而继续下次循环？即以下代码中：create or replace procedure cur_test12 isbegin declare type emp_sor_type is ref cursor; emp_sor emp_sor_type; vname employ.pname%type; --vtime number; str_sql varchar2(100); vcount number; begin --vtime := 1; open emp_sor for select pname from employ; loop fetch emp_sor into vname; ---if vtime = 1 then if vname is not null then str_sql := 'select count(*) from employ where pname=''' || vname || ''''; execute immediate str_sql into vcount; end if; exit when emp_sor%notfound; dbms_output.put_line(vname || ',' || vcount); --if vcount > 1 then --vtime := vtime + 1; --else --vtime := 1; --end if; --else --goto next_loop; --end if; end loop; -- <<next_loop>> --return; close emp_sor; end;end cur_test12;其得到的结果如图。我需要昆凌羽和陈羽祥的结果只出现一次，请问要怎么操作呢？
代码如图
后面还有end；end cur_test12；





Answer 1

用BREAK就行