Re: HELP/LOCKS/ORACLE
Date: 23 Mar 1994 02:36:58 GMT
Message-ID: <2moa0a$q6o_at_anaxagoras.ils.nwu.edu>
Subject: Re: HELP/LOCKS/ORACLE
From: Jose Patino, patinoj_at_merlin.incae.ac.cr
Date: Tue, 22 Mar 1994 15:49:18 GMT
In article <patinoj.4.0010D2DB_at_merlin.incae.ac.cr: Jose Patino,
patinoj_at_merlin.incae.ac.cr writes:
:In article <Cn2LGv.I0M_at_inesc.pt: vmm_at_avila.inesc.pt (Vasco Miguel
Miranda) writes:
::From: vmm_at_avila.inesc.pt (Vasco Miguel Miranda)
::Subject: HELP/LOCKS/ORACLE
::Date: Tue, 22 Mar 1994 14:26:55 GMT
:: Could someone please tell me if ORACLE supports the concept of
:: read lock on a row, i.e. is it possible to explicitly lock a
:: row ( for as long as we want ) in such a way that several users
can
:: read it but no one can write on it ?
:: Thank you very much for any help that you can give.
:
:
: Try using the SELECT FOR UPDATE clause .
No, this creates a write (exclusive) row lock (only one reader or writer may own such a lock). Oracle does not support share row locks. You need to find other ways to serialize your transactions. Received on Wed Mar 23 1994 - 03:36:58 CET