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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Select TOP in Oracle

Re: SQL Select TOP in Oracle

From: <mike_st0ne_at_my-deja.com>
Date: Tue, 23 Jan 2001 11:25:09 GMT
Message-ID: <94jpmh$i0r$1@nnrp1.deja.com>

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

Original text of this message

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