You can use this syntax to update a column that has a ROW data
type.
You can include any number of "single column = single expression"
terms. The expression can be an SQL subquery (enclosed between
parentheses) that returns a single row, provided that the corresponding column is
of a data type that can store the value (or the set of values) from
the row that the subquery returns.
To specify values of a ROW-type column in a SET clause, see Updating ROW-Type Columns. The following examples
illustrate the single-column format of the SET clause.
UPDATE customer
SET address1 = '1111 Alder Court', city = 'Palo Alto',
zipcode = '94301'WHERE customer_num = 103;
UPDATE stock
SET unit_price = unit_price * 1.07;