Update existing data in a database.
UPDATE table_spec SET column-assignments [WHERE < predicate-list | CURRENT > [ < ON / OF > [ CURSOR ] cursor ] ] [WITH options]
Required. The name of the table containing the data to be updated.
Required. A comma separated list of column name/new value pairs. (column-name = new-value, …)
Optional. Provide a predicate-list to qualify specific rows to be updated or update only the CURRENT row. Caution! If omitted, ALL rows will be updated with the new values. predicate-list - Criteria to determine which rows will be updated. CURRENT - Update only the current row.
Optional. The cursor on which to perform the delete. If omitted, the delete will be performed on the current cursor.
[WITH options] Optional - Specify options to be used for this command.
UPDATE INVENTORY SET PRICE=10.95 WHERE PRICE=9.95