|Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)
|PDF · Mobi · ePub|
update_set_clause, you can specify a record. For each selected row, the
UPDATE statement updates each column with the value of the corresponding record field.
where_clause, you can specify a
OF clause, which restricts the
UPDATE statement to the current row of the specified cursor.
See Also:Oracle Database SQL Language Reference for the syntax of the SQL
Name of a record variable that represents a row of the item described by
dml_table_expression_clause. That is, for every column of the row, the record must have a field with a compatible data type. If a column has a
NULL constraint, then its corresponding field cannot have a
Name of a
UPDATE cursor; that is, an explicit cursor associated with a