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: manually lock a record?

Re: manually lock a record?

From: David Freitag <dovidf_at_net2phone.com>
Date: Wed, 28 Jul 1999 12:07:42 -0400
Message-ID: <7nn9s4$lf2@nnrp3.farm.idt.net> 






Mark Ayzenshteyn <marka_at_bonzo.org> wrote in message
news:YwFn3.20665$Sg6.187144_at_news1.rdc1.sdca.home.com...


> Hi all,


>


> Is it possible to manually lock a record in oracle7/8. That is do


> a SELECT ... exclusivly lock the results





select ... for update (nowait.. if you don't want to wait for a lock). An
update opertion will clear the lock.\



David




Received on Wed Jul 28 1999 - 11:07:42 CDT












Original text of this message













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