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

Home -> Community -> Usenet -> c.d.o.server -> Re: Regarding reading records before a transaction started

Re: Regarding reading records before a transaction started

From: <xhoster_at_gmail.com>
Date: 01 Dec 2005 00:17:53 GMT
Message-ID: <20051130191753.785$Ty@newsreader.com> 





"Joel Garry" <joel-garry_at_home.com> wrote:


> What if two other users change the value of X to Z and W?




Then you are not using Oracle.



The "outer" transaction locks the row when it performs the initial update.
Other users trying to update that row will be blocked.



Xho


-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB


Received on Wed Nov 30 2005 - 18:17:53 CST












Original text of this message













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