Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: update nested select locking?
> "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
![]() |
![]() |