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博客

dbms_sql包所有子过程及函数

Summary of DBMS_SQL Subprograms

最新文章