Shishir,
When you make the select statement at the end add the clause FOR UPDATE
SELECT FIELD1, FIELD2 FROM TABLE
WHERE
FIELD1 = 40
FOR UPDATE
Luck,
-----Original Message----- Sent: Thursday, 07 March, 2002 10:03 AM To: Multiple recipients of list ORACLE-L 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
<<winmail.dat>>
