導(dǎo)讀:1建站知識(shí)至于return和exit在oracle存儲(chǔ)過(guò)程中的應(yīng)用，有些新手朋友們還是比較容易混淆的，本文將針對(duì)這兩個(gè)關(guān)鍵字進(jìn)行詳細(xì)對(duì)網(wǎng)站建設(shè)教程個(gè)業(yè)網(wǎng)站建設(shè)公司。

復(fù)制代碼 代碼如下:

create or replace procedure Test5(o_cellphone in varchar2) is v_cellphone cc_quiz_stat.cellphone %type; v_name cc_quiz_stat %rowtype; v_state cc_quiz_stat.state %type; begin declare cursor cur_cc is select * from cc_quiz_stat; cursor cur_jc(v_n varchar2) is select state from cc_quiz_stat; begin open cur_cc; loop fetch cur_cc into v_name; exit when cur_cc%notfound; open cur_jc(o_cellphone); loop fetch cur_jc into 網(wǎng)站seo優(yōu)化v_state; exit when cur_jc %notfound; if (o_cellphone = v_name.cellphone) then return; else dbms_output.put_line('手機(jī)號(hào)' || v_name.cellphone || '省份' || v_state); end if; end loop; close cur_jc; end loop; close cur_cc; end; end Test5;

執(zhí)行結(jié)果 手機(jī)號(hào)18900000000省份全國(guó) 手機(jī)號(hào)18900000000省份南京 手機(jī)號(hào)18900000000省份天津 手機(jī)號(hào)18900000000省份 上海 手機(jī)號(hào)18900000000省份北京

復(fù)制代碼 代碼如下:

create or replace procedure Test5(o_cellphone in varchar2) is v_cellphone cc_quiz_stat.cellphone %type; v_name cc_quiz_stat %rowtype; v_state cc_quiz_stat.state %type; begin declare cursor cur_cc is se網(wǎng)站建設(shè)lect * from cc_quiz_stat; cursor cur_jc(v_n varchar2) is select state from cc_quiz_stat; begin open cur_cc; loop fetch cur_cc into v_name; exit when cur_cc%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('手機(jī)號(hào)' || v_name.cellphone || '省份' || v_state); end if; end loop; close cur_jc; end loop; close cur_cc; end; end Test5;

執(zhí)行結(jié)果 手機(jī)號(hào)18900000000省份全國(guó) 手機(jī)號(hào)18900000000省份南京 手機(jī)號(hào)18900000000省份天津 手機(jī)號(hào)18900000000省份 上海 手機(jī)號(hào)18900000000省份北京 手機(jī)號(hào)18900000002省份全國(guó) 手機(jī)號(hào)18900000002省份南京 手機(jī)號(hào)18900000002省份天津 手機(jī)號(hào)18900000002省份 上海 手機(jī)號(hào)18900000002省份北京 手機(jī)號(hào)18900000003省份全國(guó) 手機(jī)號(hào)18900000003省份南京 手機(jī)號(hào)18900000003省份天津 手機(jī)號(hào)18900000003省份 上海 手機(jī)號(hào)18900000003省份北京 手機(jī)號(hào)18900000004省份全國(guó) 手機(jī)號(hào)18900000004省份南京 手機(jī)號(hào)18900000004省份天津 手機(jī)號(hào)18900000004省份 上海 手機(jī)號(hào)18900000004省份北京 return 跳出整個(gè)循環(huán)，本循環(huán)后面的不再執(zhí)行， exit 跳出本次循環(huán)，下次繼續(xù)執(zhí)行本次循環(huán)相關(guān)[企業(yè)網(wǎng)站建設(shè)標(biāo)簽:植入關(guān)鍵詞]。

關(guān)鍵詞標(biāo)簽: 區(qū)別 過(guò)程中