FOR statement associates a cursor variable with a query, allocates database resources to process the query, identifies the result set, and positions the cursor before the first row of the result set. If the query has a
UPDATE clause, then the
FOR statement locks the rows of the result set.
Name of a cursor variable. If
cursor_variable is the formal parameter of a subprogram, then it must not have a return type. For information about cursor variables as subprogram parameters, see "Cursor Variables as Subprogram Parameters".
Name of a cursor variable that was declared in a PL/SQL host environment and passed to PL/SQL as a bind variable. Do not put space between the colon (:) and
The data type of a host cursor variable is compatible with the return type of any PL/SQL cursor variable.
SELECT statement (not a PL/SQL
INTO statement). Typically,
select_statement returns multiple rows.
See:Oracle Database SQL Language Reference for
String literal, string variable, or string expression of the data type
CLOB, which represents a SQL
SELECT statement. Typically,
dynamic_statement represents a SQL
SELECT statement that returns multiple rows.
Specifies bind variables, using positional notation.
Note:If you repeat placeholder names in
dynamic_sql_statement, be aware that the way placeholders are associated with bind variables depends on the kind of dynamic SQL statement. For details, see "Repeated Placeholder Names in Dynamic SQL Statements."
Use if and only if
dynamic_sql_stmt includes placeholders for bind variables.
dynamic_sql_stmt has a
using_clause can contain only
IN bind variables. The bind variables in the
INTO clause are
OUT bind variables by definition.
Expression whose value replaces its corresponding placeholder in
dynamic_string at run time. You must specify a
bind_argument for every placeholder.
Parameter modes of bind variables. An
IN bind variable passes its value to the
OUT bind variable stores a value that
dynamic_string returns. An
OUT bind variable passes its initial value to
dynamic_string and stores a value that
dynamic_string returns. Default: