Dear fnds,

1. Is it possible to lock a row in Oracle and unlock in a different session?
2. And if yes what is the command?
3. Also is there any command to lock a particular rows in the table???


Please help me....


Thanks,
Mohan

Hi Mohan,

Here is an overview of Oracle row level locking:

http://www.dba-oracle.com/t_locks_row_level_locking.htm


>> Also is there any command to lock a particular rows in the table???

What kind of lock?

You can set lock with many commands, like "select for update"

http://www.fast-track.cc/t_easyoracle_pl_s..._for_update.htm

1. yes
2. alter system kill session 'sid,serial#';
3. see above