I guess Jonathan or some of the other in-depth contributors could point you
to where to discover which rows are locked. I am having a hard time
imagining what application would need this design. I could also imagine that
it might well take longer to discover which rows are locked than the locks
are actually held for.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<mikedba_at_my-deja.com> wrote in message news:94j7gg$4ek$1_at_nnrp1.deja.com...
> 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/
Received on Tue Jan 23 2001 - 05:42:28 CST
