Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Theoretical Basis for SELECT FOR UPDATE

Re: Theoretical Basis for SELECT FOR UPDATE

From: Tony Andrews <andrewst_at_onetel.com>
Date: 30 Sep 2005 05:35:07 -0700
Message-ID: <1128083707.470935.241420@g49g2000cwa.googlegroups.com>


x wrote:
> "Tony Andrews" <andrewst_at_onetel.com> wrote in message
> news:1128080541.493388.182640_at_f14g2000cwb.googlegroups.com...
> > Marshall Spight wrote:
>
> > I would say that SELECT FOR UPDATE is a valid facility in a DBMS that
> > supports multi-statement transactions, even when cursors are not being
> > used. It provides a means of locking data that was selected earlier in
> > the transaction so that subsequent operations can use the selected data
> > without risking violation of ACID properties (e.g. because another user
> > deleted that row).
>
> Locking is not part of the logical model. It has no place in a SELECT
> statement.

Where would you say it belongs then? Received on Fri Sep 30 2005 - 07:35:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US