實(shí)驗(yàn)五高級(jí)plsql程序設(shè)計(jì)

1、實(shí)驗(yàn)五：高級(jí)實(shí)驗(yàn)五：高級(jí)PLSQLPLSQL程序設(shè)計(jì)程序設(shè)計(jì)1.1.實(shí)驗(yàn)?zāi)康膶?shí)驗(yàn)?zāi)康氖煜ず驼莆誔LSQL中關(guān)于存儲(chǔ)過程、函數(shù)、包等高級(jí)程序設(shè)計(jì)技術(shù)。2.2.實(shí)驗(yàn)內(nèi)容實(shí)驗(yàn)內(nèi)容（1）在實(shí)驗(yàn)四的基礎(chǔ)上，把去除表的重復(fù)數(shù)據(jù)以建立主鍵約束的匿名程序塊，建立相應(yīng)的存儲(chǔ)過程，并學(xué)會(huì)使用acleSQLDEVELOPER工具對(duì)存儲(chǔ)過程進(jìn)行調(diào)試。存儲(chǔ)過程：createreplacePROCEDUREdel_du_testASBEGINtestWHEREro

2、widnotin(min(rowid)FROMtestGROUPBYpaperid)ENDdel_du_test執(zhí)行存儲(chǔ)過程：SETSERVEROUTONbegindel_du_testend存儲(chǔ)過程：createreplacePROCEDUREdel_du_curs_testASvar_paperidtest.paperid%TYPECURStest_cursISpaperidFROMtestGROUPBYpaperidHAVINGc

3、ount(paperid)1BEGINtestWHERErowidnotin(min(rowid)FROMtestGROUPBYpaperid)ENDdel_du_curs_test執(zhí)行存儲(chǔ)過程：SETSERVEROUTONbegindel_du_curs_testENDf_del_du_curs_testDECLAREl_strVAR2(100):=NULLBEGINl_str:=f_del_du_curs_test()DBMS_OU

4、TPUT.PUT_LINE(l_str)END（3）建立一個(gè)程序包，包含（1）和（2）中實(shí)現(xiàn)的存儲(chǔ)過程和函數(shù)，并通過包來調(diào)用相應(yīng)的存儲(chǔ)過程和函數(shù)。包頭：CREATEREPLACEPACKAGEdel_duASPROCEDUREdel_du_testPROCEDUREdel_du_curs_testFUNCTIONF_DEL_DU_TESTRETURNVAR2FUNCTIONF_DEL_DU_CURS_TESTRETURNVAR2ENDd

5、el_du包體：createreplacepackagebody“DEL_DU“isfunctionF_DEL_DU_CURS_TESTreturnVAR2asvar_paperidtest.paperid%TYPECURStest_cursISpaperidFROMtestGROUPBYpaperidHAVINGcount(paperid)1BEGINOPENtest_cursLOOPFETCHtest_cursINTOvar_pap