oracle 數(shù)據(jù)庫游標(biāo)使用大全

1、acle游標(biāo)使用大全游標(biāo)使用大全目錄目錄acle游標(biāo)使用大全.......................................................................................................................11.游標(biāo)簡(jiǎn)介................................................................

2、............................................................22.查詢…INTO…................................................................................................23.%TYPE屬性...........................................

3、..........................................................................24.其他DML語句.................................................................................................................35.DML語句的結(jié)果............

4、..................................................................................................35.1SQL%FOUND和SQL%NOTFOUND.................................................................35.2SQL%ROWCOUNT...............

5、...............................................................................45.3SQL%ISOPEN.......................................................................................................46.事務(wù)控制語句...............

6、.....................................................................................................47.顯式游標(biāo)與隱式游標(biāo)........................................................................................................48.

7、使用游標(biāo)............................................................................................................................78.1聲明游標(biāo)....................................................................................

8、.................................78.2打開游標(biāo).....................................................................................................................78.3關(guān)閉游標(biāo)......................................................

9、...............................................................78.4從游標(biāo)提取數(shù)據(jù).........................................................................................................88.5記錄變量.................................

10、....................................................................................98.6帶參數(shù)的游標(biāo).............................................................................................................98.7游標(biāo)F循環(huán)........

11、.................................................................................................118.8在游標(biāo)F循環(huán)中使用查詢.................................................................................128.9游標(biāo)中的子查詢..............

12、.........................................................................................128.10游標(biāo)中的更新和刪除.............................................................................................12V_BV_A%TYPE:=15V_CV_A

13、%TYPEBEGINDBMS_OUTPUT.PUT_LINE(V_A=||V_A||V_B=||V_B||V_C=||V_C)ENDSQLV_A=10V_B=15V_C=PLSQLproceduresuccessfullycompleted.SQL4.其他其他DML語句語句其它操作數(shù)據(jù)的DML語句是:、UPDATE、和LOCKTABLE這些語句在PLSQL中的語法與在SQL中的語法相同。我們?cè)谇懊嬉呀?jīng)討論過DML語句的使用這里就不再重復(fù)

14、了。在DML語句中可以使用任何在DECLARE部分聲明的變量，如果是嵌套塊，那么要注意變量的作用范圍。例：CREATEREPLACEPROCEDUREFIRE_EMPLOYEE(pempnoinnumber)ASv_enameEMP.ENAME%TYPEBEGINenameINTOv_enameFROMempWHEREempno=p_empnoINTOFMER_EMP(EMPNOENAME)VALUES(p_empnov_ename)e

15、mpWHEREempno=p_empnoUPDATEfmer_empSETdate_d=SYSDATEWHEREempno=p_empnoEXCEPTIONWHENNO_DATA_FOUNDTHENDBMS_OUTPUT.PUT_LINE(EmployeeNumberNotFound!)END5.DML語句的結(jié)果語句的結(jié)果當(dāng)執(zhí)行一條DML語句后，DML語句的結(jié)果保存在四個(gè)游標(biāo)屬性中，這些屬性用于控制程序流程或者了解程序的狀態(tài)。當(dāng)運(yùn)行DM