Re: help: DELETE with NOWAIT ?

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Mon, 16 Oct 2000 21:35:43 GMT
Message-ID: <8sfsbf$6b4$1@nnrp1.deja.com>

In article <bwIG5.2728$3U.159674_at_dfiatx1-snr1.gtei.net>, "Bill Weinberger" <billw.at.YOUKNOW.startrekmail.dot.com_at_gte.net> 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
>

Just use select for update nowait on rows you want to delete before deleting. It will lock them for every session but yours.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 16:35:43 CDT