UPDATE
Update existing data in a database.
Syntax
UPDATE table SET column-assignments [WHERE <predicate-list
| CURRENT> [<ON / OF> [CURSOR] cursor]] [WITH options]
UPDATE
Required.
table
Required. The name of the table containing the data to be updated
column-assignments.
column-assignments
Required. A comma separated list of column name/new value pairs. (column-name
= new-value, ...)
WHERE predicate-list | CURRENT
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.
[ON [CURSOR] cursor]
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.
Options
Example
This example creates an OST that contains customers who have canceled
their order. Then customers whose orders are on back order, are added
to the OST.
UPDATE INVENTORY SET PRICE=10.95 WHERE PRICE=9.95
Top
|