Show TOC

update_statementLocate this document in the navigation structure

			
<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.  !>