Re: "Transactions are bad, real bad" - discuss

"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message news:<C1Vra.7$i92.25_at_news.oracle.com>...

> > What about?
> >
> > update Accounts set Balance := Balance - 1000000
> > where AccountOwner = 'Paul Vernon',
> > update Accounts set Balance := Balance + 1000000
> > where AccountOwner = 'Jonathan Leffler';
> >
> > It is a lot easier to understand.
>
> Certainly easier to understand, but Paul suggested that any set of updates
> can be equivalently expressed as a single update.

But my proposal is a single update expression!

See the comma on the second's line end.

Regards
  Alfredo Received on Sat May 03 2003 - 13:41:35 CDT