3. Statements : OpenROAD SQL Statements : Update Statement : Where Clause
 
Share this page                  
Where Clause
If you do not include a where clause, OpenROAD updates all of the rows in the table. If you include a where clause, OpenROAD updates only the rows in the table that satisfy searchcondition in the where clause.
The "where current of" clause directs OpenROAD to update the row on which the specified cursor is positioned. The cursor_variable must point to a CursorObject that you opened using a for update clause.