System Reference Summary : 2. Statements : OpenROAD SQL Statements : Update Statement
 
Share this page                  
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