There is a clause WHERE CURRENT OF when u declare a explicit cursor.
What this clause does is that it will update or delete the current row where the cursor is pointing to.This is beneficial as Oracle doesnot have to search for ROWID in order to update or delete the row.Where the pointer of the cursor is there ,it will update/delete the row in the active set.
e.g. cursor c1
is select * from emp
for update of sal where current of;
If u have any doubts please be free to write to me at