Friday, May 10, 2013

SKIP LOCKED clause in Oracle 11g


Oracle 11g introduced SKIP LOCKED clause to query the records from the table which are not locked in any other active session of the database. This looks quite similar to exclusive mode of locking. The SQL statement in Example code (15) queries the unlocked records from EMP table
Example :
SELECT * FROM EMP FOR UPDATE SKIP LOCKED

No comments:

Post a Comment