Lock timeout


(As posted by Johnathan Lewis to comp.databases.oracle.server)

Probably what every developer has been waiting years for - the ability to make an attempt to lock a record within a certain time span.

select * from MY_TABLE for update WAIT 5;