Re: Theoretical Basis for SELECT FOR UPDATE
From: vc <boston103_at_hotmail.com>
Date: 4 Oct 2005 08:57:16 -0700
Message-ID: <1128441436.819898.177090_at_g44g2000cwa.googlegroups.com>
Date: 4 Oct 2005 08:57:16 -0700
Message-ID: <1128441436.819898.177090_at_g44g2000cwa.googlegroups.com>
Tony Andrews wrote:
> 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!