Syntax

1. <update_statement> ::=
     UPDATE [OF] <table_name>
       [<reference_name>]
       SET <set_update_clause>,...
       [KEY <key_spec>,..] <!  This SQL clause is
             no longer recommended to be used and
             might be removed from future versions.  !>
       [WHERE <search_condition>]
       [NOWAIT]
       [IGNORE TRIGGER]
   | UPDATE [OF] <table_name>
       [<reference_name>]
       SET <set_update_clause>,...
       WHERE CURRENT OF <result_table_name>
       [NOWAIT]
   | UPDATE [OF] <table_name>
       [<reference_name>]
       (<column_name>,...)
       VALUES (<extended_value_spec>,...)
       [KEY <key_spec>,...]
       [WHERE <search_condition>]
       [NOWAIT]
       [IGNORE TRIGGER]
   <!  This SQL clause is no longer recommended to be used 
       and might be removed from future versions.  !>
   | UPDATE [OF] <table_name>
       [<reference_name>]
       (<column_name>,...
       VALUES (<extended_value_spec>,...)
       WHERE CURRENT OF <result_table_name>
       [NOWAIT]
   <!  This SQL clause is no longer recommended to be used 
       and might be removed from future versions.  !>