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

1、oracleexit,oraclereturnexit区别概述及测试代码如下:create or replace procedure Test5(o_cellphone in varchar2) isv_cellphone cc_quiz_stat.cellphone %type;v_name cc_quiz_stat %rowtype;v_state cc_quiz_stat.state %type;begindeclarecursor cur_cc isselect * from cc_quiz_stat;cursor cur_jc(v_n varchar2) isselect state

2、 from cc_quiz_stat;beginopen cur_cc;loopfetch cur_ccinto v_name;exit when cur_cc%notfound;open cur_jc(o_cellphone);loopfetch cur_jcinto v_state;exit when cur_jc %notfound;if (o_cellphone = v_name.cellphone) thenreturn;elsedbms_output.put_line(机号 | v_name.cellphone | 省份|v_state);end if;end loop;close

3、 cur_jc;end loop;close cur_cc;end;end Test5;执结果机份全国机份南京机份天津机份 上海机份北京复制代码代码如下:create or replace procedure Test5(o_cellphone in varchar2) isv_cellphone cc_quiz_stat.cellphone %type;v_name cc_quiz_stat %rowtype;v_state cc_quiz_stat.state

4、%type;begindeclarecursor cur_cc isselect * from cc_quiz_stat;cursor cur_jc(v_n varchar2) isselect state from cc_quiz_stat;beginopen cur_cc;loopfetch cur_ccinto v_name;exit when cur_cc%notfound;open cur_jc(o_cellphone);loopfetch cur_jcinto v_state;exit when cur_jc %notfound;if (o_cellphone = v_name.c

5、ellphone) thenexit;elsedbms_output.put_line(机号 | v_name.cellphone | 省份|v_state);end if;end loop;close cur_jc;end loop;close cur_cc;end;end Test5;执结果机份全国机份南京机份天津机份 上海机份北京机份全国机份南京机份天津机份 上海机份北京机份全国机份南京机份天津机份 上海机份北京机份全国机份南京机号18900000