Hi all,
I just found out that if i issue two update statements on the same column of a table in 2 different sessions then one session hangs till i issue a rollback or commit in the other session. For eg i issued 2 statements as follows :

1 .update emp1 set sal = 2566 where deptno = 20 ;
2 .update emp1 set sal = 1500 where deptno = 20 ;

So here command one completes successfully but the second session hangs until i issue a commit or rollback in session 1.

This must be due to the locking techniques of Oracle and isolation levels etc. but what i want to know is whether this is the default behaviour in Oracle or can we change it. Also can somebody suggest me some good links on this topic for further reading.

Thanks a lot in advance