It is
my understanding that Shishir is SELECTing a record, viewing it, making a change
to the data and then updating it. Normally, another user can
slip in and update the row, so he wants to make sure that no one else
does.
For
example, in a hotel room reservation system, you would prompt the system
for an available room. You would then probably reserve that room for a
particular customer. If there was no lock on that room (record) then your
guest might discover someone else in the room. Ops.
-----Original Message-----Hi Shishir,
From: Ora NT DBA [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: row level lock
This is oracle's default behaviour. As you update , insert or delete a row oracle places a lock at the row level.
John HOugh
[EMAIL PROTECTED] wrote:
HI list!I want to lock a table on row level ( not table level) . how do we pass the pass that value in syntax which will lock only those rows. plz make me understand by giving an example.thanx in advance..
