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

Home -> Community -> Usenet -> c.d.o.misc -> Re: update nested select locking?

Re: update nested select locking?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 27 Jul 2006 20:30:38 +0200
Message-ID: <44c9064e$0$29876$626a54ce@news.free.fr> 






> "Michael" <mjswanson_at_gmail.com> a écrit dans le message de news: 1154022430.028503.40330_at_i3g2000cwc.googlegroups.com...

> Darn it, I'm sorry.

>

> Is this atomic:

>

> update tbl set col = (select sum(col + 1) from tlb where rownum = 1);




Yes.


Each and every DML statement is atomic and see the database
as it was when the statement started (or restarted).



Regards


Michel Cadot
Received on Thu Jul 27 2006 - 13:30:38 CDT












Original text of this message













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