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: x <x_at_not-exists.org>
Date: Fri, 30 Sep 2005 12:17:54 +0300
Message-ID: <dhivs8$nln$1@domitilla.aioe.org>


My question is this: what is the best way for putting toghether two languages (the host language and the data sublanguage) without breaking the ACID and maximizing concurrency.

A cursor try to imitate a sequential file of records.

"Marshall Spight" <marshall.spight_at_gmail.com> wrote in message news:1128057843.378642.38150_at_z14g2000cwz.googlegroups.com...
> Hi all,
>
> I am interested to hear people's opinions on the validity
> of SELECT FOR UPDATE. It is not something that I've ever
> had to use, or even felt the need for, but I don't confuse
> that fact with any kind of proof or disproof of the technique's
> essentiality.
>
> Also, if I understand correctly, TTM doesn't like it at all,
> either. It appears "RM Proscription 7" forbids the technique.
> I give a fair bit of weight to TTM, but I don't necessarily
> agree with everything it says, nor do I believe that the
> solutions it proposes to problems are the only or even
> the best solutions. In this case, they simply disallow it,
> but don't provide any alternative, which suggests that they
> feel it is simply unnecessary.
>
> I am interested to hear people's experiences, and especially
> any insight into the "true nature" of cursors and/or select
> for update, and whether it is in fact necessary.
>
>
> Marshall
>
Received on Fri Sep 30 2005 - 04:17:54 CDT

Original text of this message

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