Dear gurus !
I apologize for wasting your time.
I have had a second thought and realized that option (2) is not feasible,
simply because i might miss some records, i.e. delete the records that are
inserted into MYTAB DURING the execution of the cursor.
I.e. , time will pass between the opening of
:
Sent by: Subject: a quick SQL performance
question - rethinked
[EMAIL PROTECTED
Hi Andrey,
If the volume of rows is not too great, you can use a technique I've used. Retrieve
the rowids and store them in a PL/SQL table as you process them. At the end of the
processing loop, use a forall loop to delete the rows using the PL/SQL table. I know
a 2000 row PL/SQL table