Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Cursor, loop and delete...
Hello,
A small example would be better than a lot of words. Can I do this ?
<<<
declare
cursor myCursor is select objectid from myTable where value = 'TEST'; begin
for myRecord in myCursor loop
delete from myTable where objectid = myRecord.objectid; commit;
I would really appreciate to be able to do this but I am afraid of side effects, because I modify the cursor data set during its usage.
Which precaution must I take ? Any advice welcome.
Thanks a lot
AD Received on Mon Aug 02 2004 - 10:25:08 CDT