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?
EXCLUSIVE LOCKS IN SQL
Who is online
Users browsing this forum: No registered users and 9 guests