RE: row level lock

From: Grabowy, Chris <cgrabowy_at_fcg.com>
Date: Thu, 07 Mar 2002 09:38:29 -0800
Message-ID: <F001.00422281.20020307093829@fatcity.com>

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-----
Sent: Thursday, March 07, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L

Hi Shishir,

This is oracle's default behaviour. As you update , insert or delete a row oracle places a lock at the row level.

John HOugh

shishir_at_agnisoft.com <mailto:shishir_at_agnisoft.com> 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..
Shishir Kumar Mishra
Agni Software (P) Ltd.,
Bangalore-560055, India
www.agnisoft.com <http://www.agnisoft.com>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 07 2002 - 11:38:29 CST