UPDATE Statement Extensions

PL/SQL extends the update_set_clause and where_clause of the SQL UPDATE statement as follows:

• In the 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.

• In the where_clause, you can specify a CURRENT OF clause, which restricts the UPDATE statement to the current row of the specified cursor.

Topics:

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

update_set_clause ::=

where_clause ::=

Semantics

record_name

The name of a record variable of type RECORD or %ROWTYPE. The record must represent 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 NOT NULL constraint, then its corresponding field cannot have a NULL value.

for_update_cursor_name

The name of a FOR UPDATE cursor; that is, an explicit cursor associated with a FOR SELECT UPDATE statement.

Examples

• Example 5-53, "Updating Rows with a Record"

• Example 6-44, "FOR UPDATE Cursor in CURRENT OF Clause of UPDATE Statement"

Related Topics

In this chapter:

• "Explicit Cursor"

• "Record"

• "%ROWTYPE Attribute"

In other chapters:

• "Updating Rows with Records"

• "Restrictions on Record Inserts and Updates"

• "SELECT FOR UPDATE and FOR UPDATE Cursors"