Re: Locks rows

From: Yong Huang <yong321_at_yahoo.com>
Date: 20 Jan 2003 15:54:54 -0800
Message-ID: <b3cb12d6.0301201554.3cb1209b@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 Received on Mon Jan 20 2003 - 17:54:54 CST