Re: update nested select locking?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 27 Jul 2006 18:21:36 +0200
Message-ID: <44c8e810$0$23360$626a54ce@news.free.fr>

"Michael" <mjswanson_at_gmail.com> a écrit dans le message de news: 1154011182.500439.50280_at_s13g2000cwa.googlegroups.com...
| Could someone please settle an disagreement:
|
| Is the following an atomic operation or is dirty data possible:
|
| create tbl
| (
| col number;
| );
|
| insert into tbl values (0);
|
| update tbl set col = (select sum(col + 1) from tlb where rownum = 1);
|
| Or does it need to be in a transaction? Or should a "for update" be
| used.
|
| Thank you.
|

I see 3 operations which one are you talinkg about? What is your Oracle version?

Regards
Michel Cadot Received on Thu Jul 27 2006 - 11:21:36 CDT