UPDATE
This statement changes one or more existing values in a table.
Syntax
<update-stmt> ::= UPDATE <table_name> SET <set-value-list>
[<where-clause>]
<set-value-list> ::= <set-value-item> [,<set-value-item>]...
<set-value-item> ::= <column-name> = NULL
| <column-name> = <value-expression>
Examples
UPDATE emp SET sal = sal+1000 WHERE empno>100
UPDATE emp SET comm = 0 WHERE empno > 100 AND deptno = 2
