dbms_sql包所有子過程及函式
Summary of DBMS_SQL Subprograms
Table 100-1 DBMS_SQL Package Subprograms
Subprogram | Description |
---|---|
Binds a given value to a given collection | |
Binds a given value to a given variable | |
Closes given cursor and frees memory | |
Returns value of the cursor element for a given position in a cursor | |
Returns a selected part of a LONG column, that has been defined using DEFINE_COLUMN_LONG | |
Defines a collection to be selected from the given cursor, used only with SELECT statements | |
Defines a column to be selected from the given cursor, used only with SELECT statements | |
Defines a LONG column to be selected from the given cursor, used only with SELECT statements | |
Describes the columns for a cursor opened and parsed through DBMS_SQL | |
Describes describes the specified column, an alternative to DESCRIBE_COLUMNS Procedure | |
Executes a given cursor | |
Executes a given cursor and fetch rows | |
Fetches a row from a given cursor | |
Returns TRUE if given cursor is open | |
Returns byte offset in the SQL statement text where the error occurred | |
Returns cumulative count of the number of rows fetched | |
Returns ROWID of last row processed | |
Returns SQL function code for statement | |
Returns cursor ID number of new cursor | |
Parses given statement | |
Returns value of named variable for given cursor |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-670029/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- VBA過程―子程式與函式(轉)函式
- openGauss 函式及儲存過程支援函式儲存過程
- vue所有生命週期函式/鉤子函式理解Vue函式
- mysql儲存過程及日期函式實踐MySql儲存過程函式
- 觸發器trigger中呼叫包package(包中含:儲存過程procedure及函式function)_plsql觸發器Package儲存過程函式FunctionSQL
- day25-索引和函式及儲存過程索引函式儲存過程
- 儲存過程 函式儲存過程函式
- 學習DBMS_PROFILER包診斷儲存過程及函式的情能及引申思考儲存過程函式
- 函式棧幀(呼叫過程)函式
- 儲存過程與函式儲存過程函式
- Oracle 過程(Procedure)、函式(Function)、包(Package)、觸發器(Trigger)Oracle函式FunctionPackage觸發器
- 編寫電子書包平臺所有表主鍵之儲存過程_sp_stored procedure儲存過程
- 閃回之 Flashback Query (dml表、過程、函式、包等)、Flashback version Query函式
- 刪除資料庫中所有儲存過程和函式的sql語句資料庫儲存過程函式SQL
- MySQL 儲存過程和函式MySql儲存過程函式
- MySQL儲存過程 (即函式)MySql儲存過程函式
- MySQL儲存過程和函式MySql儲存過程函式
- oracle 過程函式定義字典Oracle函式
- mySql 儲存過程與函式MySql儲存過程函式
- SQL server儲存過程函式SQLServer儲存過程函式
- Go 官方包函式學習及示例Go函式
- ORACLE應用經驗(3)-DBMS_SQL封裝過程(轉)OracleSQL封裝
- oracle自動生成編譯所有函式、儲存過程、觸發器的語句Oracle編譯函式儲存過程觸發器
- js函式執行過程的探究JS函式
- 儲存過程與儲存函式儲存過程儲存函式
- 儲存過程vs.函式QM儲存過程函式
- 無參過程與無參函式函式
- OnWndMsg函式的處理過程函式
- oracle 建立過程、函式中as, is區別 ?Oracle函式
- mysql儲存過程基本函式(轉)MySql儲存過程函式
- C++建構函式解構函式的執行過程C++函式
- MySQL自定義函式與儲存過程MySql函式儲存過程
- 七、函式-儲存過程-觸發器函式儲存過程觸發器
- Oracle中過程/函式返回結果集Oracle函式
- PLSQL學習-【7儲存過程、函式】SQL儲存過程函式
- 儲存過程和函式的區別儲存過程函式
- MySQL 5.5 建立儲存過程和函式MySql儲存過程函式
- MySQL4:儲存過程和函式MySql儲存過程函式