DELETE in current cursor position

[rshivagami]

Hi all,

How do I delete the record at my current cursor position, is there anything similar to 'WHERE CURRENT OF' clause as we have for Update.

Shiva.

[kmesser]

You could step through your procedure, capturing rowid info into a PL/SQL table, then do delete operation after exiting cursor FOR loop . . .

[rohitsn]

Hi,
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
rohitsn@orasearch.net

Regards,
Rohit Nirkhe,Oracle DBA,OCP

[akkerend]

You can use the WHERE CURRENT OF clause for updates and for deletes.