SET UPDATE clause
SET UPDATE clause
Syntax
<set update clause> ::= <column name> = <extended expression>
| <column name>,... = (<extended expression>,...)
| (<column name>,...) = (<extended expression>,...)
| <column name> = <subquery>
| (<column name>,...) = <subquery>
Explanation
The expression of a SET UPDATE clause must not contain a
set function.The subquery must produce a result table with at most one row. The number of columns must be equal to the number of target columns specified.
SQL statement in which the SET UPDATE clause is used
UPDATE statement