Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Select TOP in Oracle
In article <94j7gg$4ek$1_at_nnrp1.deja.com>,
mikedba_at_my-deja.com wrote:
> My client has 8.1.6, so this "rownum < 11" is
> perfect for my needs, but I'd also like to add
> another test to the WHERE clause. Specifically,
> is there a way to tell a query to ignore locked
> records? Like, AND NOT $LOCKED?
>
> I can't find anything about this in the on-line
> docs.
>
> mIKE
>
> Sent via Deja.com
> http://www.deja.com/
>
Is there some specific reason for wanting to avoid "locked" records? Or
is it just that you're conditioned by SQL*Server to expect problems in
this area?
If it's the latter reason, well, you're dealing with a real database
now. So far as Oracle is concerned, readers of data block nobody else,
and are blocked by nobody else.
Hth
Mike S
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 23 2001 - 05:25:09 CST