Skip Headers
Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)

Part Number E10472-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

UPDATE Statement Extensions

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

See Also:

Oracle Database SQL Language Reference for the syntax of the SQL UPDATE statement

Topics:

Syntax

update_set_clause ::=

integer_literal
Description of the illustration update_set_clause.gif

where_clause ::=

integer_literal
Description of the illustration where_clause.gif

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.

See Also:

Oracle Database SQL Language Reference for the complete syntax of the UPDATE statement

Examples

Related Topics

In this chapter:

In other chapters: