Re: Regarding reading records before a transaction started

xhoster_at_gmail.com wrote:
> "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.

Shoot, you are right. I've been corrupted by db-blind apps.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20051201/news_1b1patent.html