Re: Oracle 8 and locked rows

I just came across that SQL statement

SELECT * FROM table FOR UPDATE SKIP LOCKED

Which returns all the non-locked row and locks them. Is there a similar command that does that without locking them?

Thanks

> No it is not.
>
 

> > Would it be possible then, to get something like this? This not
> > asking for the list of locked row but trying to find out if a
> > given row is locked. If the lock is part of the data it should be
> > possible right?
> >
> > Item number is locked
> > ---------------------------
> > 1234123 Y
> > 4563456 N
> > 8565456 Y
                            

 Pascal Paradis-Th berge
  pascal_at_ia-us.com Received on Thu Feb 12 1998 - 00:00:00 CST