Dynamic SQL statements, including data manipulation language (DML) or data definition language (DDL) statements.
Subprocedures: OPEN_CURSOR Function Returns cursor ID number of new cursor. PARSE Parse given statement. BIND_VARIABLE Bind a given value to a given variable or collection. BIND_ARRAY Bind a given value to a given variable or collection. DEFINE_COLUMN DEFINE_COLUMN_LONG Define a column to be selected from the given cursor, used only with SELECT statements. DEFINE_ARRAY Define a collection to be selected from the given cursor, used only with SELECT statements. EXECUTE Function Execute a given cursor. EXECUTE_AND_FETCH Function Execute a given cursor and fetch rows. FETCH_ROWS Function Fetch a row from a given cursor. COLUMN_VALUE Returns value of the cursor element for a given position in a cursor. COLUMN_VALUE_LONG Returns a selected part of a LONG column, that has been defined using DEFINE_COLUMN_LONG. VARIABLE_VALUE Returns value of named variable for given cursor. IS_OPEN Function Returns TRUE if given cursor is open. DESCRIBE_COLUMNS Describe the columns for a cursor opened and parsed through DBMS_SQL. CLOSE_CURSOR Close given cursor and frees memory. LAST_ERROR_POSITION Function Return 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.
For full documentation of the packaged procedures
above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages
by Steven Feuerstein et al
Related:
EXECUTE IMMEDIATE