Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NOWAIT for row-level lock?
Hello Jerry,
The syntax is
SELECT *
FROM table_A
FOR UPDATE NOWAIT
gcunning_at_my-dejanews.com a écrit:
> Is there a way to NOT wait for a row -level lock held by another transaction?
>
> For instance, if:
>
> txn1 selects row 1 for update at a point in time. At a later time, txn2
> selects the same row for update, but txn1 still holds the lock (txn1 hasn't
> commited).
>
> Instead of waiting, is there a way to let txn2 know that the record is locked,
> so they can move on to another record?
>
> Thanks,
>
> Jerry
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Oct 23 1998 - 11:08:06 CDT