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 -> newbie row locking question

newbie row locking question

From: Jim Haran <jim_haran_at_datasoft-inc.comREMOVE_THIS>
Date: Tue, 20 Oct 1998 06:40:39 -0700
Message-ID: <362C92D7.F0BD2ACC@datasoft-inc.comREMOVE_THIS>


Hello all,

    As a recent newcomer to the Oracle world, there are a few questions I have. I have not come across documentation that covers row locking. In the old world (xBase), I would lock a record as soon as the user accessed it. As such, if another user attempted to edit the same receord, the lock would be detected and a dirty read at best would be allowed.

    Do I need to explicitly lock rows in my apps? If not how does one control possible concurrent updates to the same row? I'm sure this is covered somewhere in the documentation but I have'nt found it. Thanks in advance for any help.

Jim Received on Tue Oct 20 1998 - 08:40:39 CDT

Original text of this message

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