In Oracle, if you wish to update or delete records that have been referenced by a SELECT FOR UPDATE statement, you can use the WHERE CURRENT OF statement. The where current of statement allows you to update or delete the record that was last fetched by the cursor.
To retrieve the rows from declared cursor in Oracle, use the following syntax:
Parameters:
table_name: The table name.
set_clause: To populate the cursor result set.
cursor_name: The cursor name.
Note:
In the above example, shows how to use the WHERE CURRENT OF statement.