SQL>CONNECT SCOTT/TIGER;
SQL>LOCK TABLE EMP IN EXCLUSIVE MODE NOWAIT;
SQL>UPDATE EMP SET SAL=1000;
The NOWAIT clause is causing the system to wait instead of displaying the
message "EMP IS USED BY ANOTHER USER" while i'm manipulating EMP of SCOTT from another system/session.
WHY?
Search found 1 match
- Wed Apr 08, 2009 10:01 am
- Forum: Oracle Databases
- Topic: EXCLUSIVE LOCKS IN SQL
- Replies: 0
- Views: 2768