How to retrieve only unlocked rows
How to retrieve only those records from a table that are not locked by other users? One way
of doing it is by writing a PL/SQL code based on locking error (-54). Is there any other way of
viewing unlocked records in SQL only?
example:
Sql*plus session 1:
A user locks records with update emp set sal = sal*1.2 where deptno = 40;
Sql*plus session 2:
Another user likes to view all unlocked records from table emp and is
not aware of what is locked. What should he/she do?
SKIP LOCKED option of select for update will list unlocked records. This is an undocumented feature.
select empno, ename, job, sal
from emp
for update skip locked;
Best viewed in medium text size. Please refresh this page (F5) to view the latest information. This page was create on 15-dec-2000 and last updated on 15-dec-2000.
please forward all queries to amar_padhi@fastmail.fm