Re: HELP/LOCKS/ORACLE
From: Jose Patino <patinoj_at_merlin.incae.ac.cr>
Date: Tue, 22 Mar 1994 15:49:18 GMT
Message-ID: <patinoj.4.0010D2DB_at_merlin.incae.ac.cr>
Date: Tue, 22 Mar 1994 15:49:18 GMT
Message-ID: <patinoj.4.0010D2DB_at_merlin.incae.ac.cr>
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 . Received on Tue Mar 22 1994 - 16:49:18 CET