Re: Can I lock a Row in a Oracle Table ?

From: Nina Wiesemann <nw.th_at_rhein-main.net>
Date: Fri, 30 Apr 1999 23:18:07 +0200
Message-ID: <7gd6p8$fd7$1@newsreader.ipf.de>

Hi,

additionally you should know that a lock is released with the next commit or rollback within this db-connection

N. Wiesemann

---

Im Beitrag <372aff43.2399249_at_192.86.155.100>, tkyte_at_us.oracle.com (Thomas Kyte) schrieb:

>A copy of this was sent to Marco Andre <mandre_at_ism.com.br>
>(if that email address didn't require changing)
>On Thu, 29 Apr 1999 20:41:59 -0300, you wrote:
>
>>Can I lock a Row in a Oracle Table ? Or how can I handle one record
>>being change by two users ?
>>
>>thanks.
>
>
>select * from T where pk = value FOR UPDATE;
>
>
>will lock the row(s) selected.
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Service Industries
>Reston, VA USA
>
>--
>http://govt.us.oracle.com/ -- downloadable utilities
>
>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Fri Apr 30 1999 - 16:18:07 CDT