Update Statement
This statement updates the values of the columns in a database table.
It has the following syntax:
Non-cursor version:
[repeated] update tablename [corrname]
[from fromclause
set columnname = dbexpression{, columnname =
dbexpression}
[where searchcondition];
Cursor version:
update tablename set columnname = dbexpression
{, columnname = dbexpression} where current of
cursor_variable;
where fromclause has the following alternative syntaxes:
from tablename [corrname]{, tablename [corrname]}
from :fromvariable