The multiple-column format of the SET clause offers the
following options for listing a set of columns that you intend to
update:
Explicitly list each column, placing commas between columns and
enclosing the set of columns between parentheses.
Implicitly list all columns in the table by using an asterisk
( * ).
You must list each expression explicitly, placing comma
( , ) separators between expressions and enclosing the set of expressions
between parentheses. The number of columns must equal the number of
values returned by the expression list, unless the expression list
includes an SQL subquery.
The following examples show the multiple-column format
of the SET clause:
UPDATE customer
SET (fname, lname) = ('John', 'Doe') WHERE customer_num = 101;
UPDATE manufact
SET * = ('HNT', 'Hunter') WHERE manu_code = 'ANZ';