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

Jonathan Leffler wrote: > > I have seen a couple of answers, but neither of them addressed what I would > regard as the fundamental question, which is: > > * If you aren't interested in the values from the SELECT, why are you using > a SELECT FOR UPDATE and DELETE WHERE CURRENT OF statements? > .... > 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. Jonathan, another reason could be that he wants firstly to obtain a lock on the record he wants to delete before actually deleting it. Regards Tolis +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+