EXCLUSIVE LOCKS IN SQL

In this forum you can share stuff related to Oracle 11g, 10g, 9i.
Post Reply
sabariesh
Posts: 1
Joined: Thu Nov 27, 2008 4:18 am
Location: India

EXCLUSIVE LOCKS IN SQL

Post by sabariesh »

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?
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest