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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to test locks

Re: how to test locks

From: Mladen Gogala <mgogala_at_earthlink.net>
Date: Thu, 24 Jan 2002 02:06:41 GMT
Message-ID: <pan.2002.01.23.21.06.44.54202.1011@earthlink.net> 





On Wed, 23 Jan 2002 07:41:34 -0500, Ganesh Raja wrote:



>  I have a simple question. How can i test weather a record in a table is


>> > locked by another user without causing another lock.





>> > 





Look at the "without causing another lock" part of the requirement and
tell me why do you think that "select for update nowait" satisfies that
condition?
Received on Wed Jan 23 2002 - 20:06:41 CST












Original text of this message













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