oracle存储过程中return和exit区别概述及测试

create or replace procedure Test5(o_cellphone in varchar2) is
v_cellphone _quiz_stat.cellphone %type;
v_name _quiz_stat %rowtype;
v_state _quiz_stat.state %type;
begin
declare
cursor cur_ is
select from _quiz_stat;
cursor cur_jc(v_n varchar2) is
select state from _quiz_stat;
begin
open cur_;
loop
fetch cur_
into v_name;
exit when cur_%notfound;
open cur_jc(o_cellphone);
loop
fetch cur_jc
into v_state;
exit when cur_jc %notfound;
if (o_cellphone = v_name.cellphone) then
return;
else
dbms_output.put_line('手机号' || v_name.cellphone || '省份' ||
v_state);
end if;
end loop;
close cur_jc;
end loop;
close cur_;
end;
end Test5;

create or replace procedure Test5(o_cellphone in varchar2) is
v_cellphone _quiz_stat.cellphone %type;
v_name _quiz_stat %rowtype;
v_state _quiz_stat.state %type;
begin
declare
cursor cur_ is
select from _quiz_stat;
cursor cur_jc(v_n varchar2) is
select state from _quiz_stat;
begin
open cur_;
loop
fetch cur_
into v_name;
exit when cur_%notfound;
open cur_jc(o_cellphone);
loop
fetch cur_jc
into v_state;
exit when cur_jc %notfound;
if (o_cellphone = v_name.cellphone) then
exit;
else
dbms_output.put_line('手机号' || v_name.cellphone || '省份' ||
v_state);
end if;
end loop;
close cur_jc;
end loop;
close cur_;
end;
end Test5;