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..