Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help: DELETE with NOWAIT ?
DELETE always hangs if the row is "taken". There is no NOWAIT option.
But you can use SELECT FOR UPDATE with NOWAIT to lock the rows you are going to delete and then doing DELETE on them.
Bill Weinberger wrote:
> I know how to use NOWAIT to keep SELECT...FOR UPDATE from blocking on
> Resource busy. But, how can I accomplish the same thing when I am deleting
> rows, too?
>
> Thanks for your help.
> Bill
Received on Fri Oct 20 2000 - 10:42:34 CDT