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 -> q: diffrence between row_shared and row_exclusive lock ?

q: diffrence between row_shared and row_exclusive lock ?

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 19 Jul 2002 23:17:36 -0700
Message-ID: <44a19320.0207192217.78fe11eb@posting.google.com> 





all,



row shared lock lmode=2


row exclusive lock lmode=3



row shared is more restrictive than row exclusive.
row shared can be generated with select ... for update of
row exclusive can be generated with lock table in row exclusive mode
or update statement.





Can any one give me an working example explaining what are difference
between these two type locks - in terms why one is more restritive
than the other?



thnx in advance


ted chyn
Received on Sat Jul 20 2002 - 01:17:36 CDT












Original text of this message













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