Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Theoretical Basis for SELECT FOR UPDATE

Re: Theoretical Basis for SELECT FOR UPDATE

From: vc <boston103_at_hotmail.com>
Date: 6 Oct 2005 11:40:57 -0700
Message-ID: <1128624057.164591.271800@g44g2000cwa.googlegroups.com> 






vc wrote:


[...]


> Regarding the locking approach,  I am not sure whether it can be

> implemented at all.  How would you lock/freeze a set of rows in various

> tables to guarantee a consistent view across the database ?




Actually,  it's pretty easy to lock and select the latest value say in
SQL Server by using the updlock hint which essentially converts read
locks to write locks.
Received on Thu Oct 06 2005 - 13:40:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US