Description of the illustration merge_update_clause.eps

WHEN MATCHED THEN
  UPDATE SET column = { expr | DEFAULT }
           [, column = { expr | DEFAULT } ]...
  column_value_pairs
  [ where_clause ]  
  [ DELETE where_clause ]