Re: Theoretical Basis for SELECT FOR UPDATE

From: Tony Andrews <andrewst_at_onetel.com>
Date: 4 Oct 2005 08:09:30 -0700
Message-ID: <1128438570.722908.161130_at_g47g2000cwa.googlegroups.com>


vc wrote:
> > Yes, it would: your syntax is not valid. The commas are not merely an
> > syntactic alternative to semi-colons, they are semantically different
> > too: they indicate that the two updates are to be treated as a single
> > DML statement with no implicit ordering. You can't insert a call to
> > procedure between the two updates - that is the point of having this
> > syntax!
>
> Never mind 'print', is the update,select,update; sequence legal ?

No. There is no "sequence" here - that is the whole point! Received on Tue Oct 04 2005 - 17:09:30 CEST

Original text of this message