Re: Delete Cursor: What To Use In Select Clause?

tvarnas@compulink.gr (Apostolos Varnas) wrote: >> One possible reason for using the cursor might be that you've run into >> problems with references to the table from which you are deleting data in >> sub-queries in the WHERE clause, or something along those lines. >another reason could be that he wants firstly to obtain a lock on the record >he wants to delete before actually deleting it. I would have thought that the DELETE would have taken a lock before deleting it... How could you delete it otherwise?