SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data manipulation |
Informix® allows a specific syntax for UPDATE statements:
UPDATE table SET ( <col-list> ) = ( <val-list> )
or
UPDATE table SET table.* = myrecord.*
UPDATE table SET * = myrecord.*
Static UPDATE statements using this syntax are converted by the compiler to the standard form:
UPDATE table SET column=value [,...]