Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: update nested select locking?
On 27 Jul 2006 10:47:10 -0700, "Michael" <mjswanson_at_gmail.com> wrote:
>Darn it, I'm sorry.
>
>Is this atomic:
>
>update tbl set col = (select sum(col + 1) from tlb where rownum = 1);
No, it is top-posted.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Jul 27 2006 - 13:47:03 CDT