dbms_sql包所有子過程及函式

wisdomone1發表於2010-08-02

Summary of DBMS_SQL Subprograms

Table 100-1 DBMS_SQL Package Subprograms

Subprogram Description

BIND_ARRAY Procedures

Binds a given value to a given collection

BIND_VARIABLE Procedures

Binds a given value to a given variable

CLOSE_CURSOR Procedure

Closes given cursor and frees memory

COLUMN_VALUE Procedure

Returns value of the cursor element for a given position in a cursor

COLUMN_VALUE_LONG Procedure

Returns a selected part of a LONG column, that has been defined using DEFINE_COLUMN_LONG

DEFINE_ARRAY Procedure

Defines a collection to be selected from the given cursor, used only with SELECT statements

DEFINE_COLUMN Procedure

Defines a column to be selected from the given cursor, used only with SELECT statements

DEFINE_COLUMN_LONG Procedure

Defines a LONG column to be selected from the given cursor, used only with SELECT statements

DESCRIBE_COLUMNS Procedure

Describes the columns for a cursor opened and parsed through DBMS_SQL

DESCRIBE_COLUMNS2 Procedure

Describes describes the specified column, an alternative to DESCRIBE_COLUMNS Procedure

EXECUTE Function

Executes a given cursor

EXECUTE_AND_FETCH Function

Executes a given cursor and fetch rows

FETCH_ROWS Function

Fetches a row from a given cursor

IS_OPEN Function

Returns TRUE if given cursor is open

LAST_ERROR_POSITION Function

Returns byte offset in the SQL statement text where the error occurred

LAST_ROW_COUNT Function

Returns cumulative count of the number of rows fetched

LAST_ROW_ID Function

Returns ROWID of last row processed

LAST_SQL_FUNCTION_CODE Function

Returns SQL function code for statement

OPEN_CURSOR Function

Returns cursor ID number of new cursor

PARSE Procedure

Parses given statement

VARIABLE_VALUE Procedures

Returns value of named variable for given cursor

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-670029/,如需轉載,請註明出處,否則將追究法律責任。

相關文章