Re: Locks rows

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 21 Jan 2003 18:24:11 +1100
Message-ID: <Iq6X9.29297$jM5.75536@newsfeeds.bigpond.com>

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0301201554.3cb1209b_at_posting.google.com...
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:<AzXW9.28933$jM5.74796_at_newsfeeds.bigpond.com>...
> > won't stop me *selecting* that record. In Oracle, selects never take
locks
> > (except for the special case of a 'for update' one) and so they can't
>
> Or for the case the select is across a database link, which creates a
> DX and a TX lock in the local instance (DX is only seen by the current
> session).
>
> Yong Huang

Honestly. Do we *have* to prove the size of our penis every time we post? Do you *honestly* think that (a) this is relevant to the original poster or (b) that I wouldn't be aware of this if it were??

Whatever happened to "context"?

And why must everyone always feel obliged to add 0.0001% of truth to a post?

HJR Received on Tue Jan 21 2003 - 01:24:11 CST