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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 30 Apr 1999 00:55:00 GMT
Message-ID: <372aff43.2399249@192.86.155.100>

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 Thu Apr 29 1999 - 19:55:00 CDT