Failing fast SQL
create table so_when_someone_else_has_this (im_sooooo_impatient integer, i_just_cant_delay integer);
insert into so_when_someone_else_has_this values (1, 1);
commit;
delete so_when_someone_else_has_this;
-- Run in a second session
-- and you'll receive ORA-00054, so you probably need some error handling for this
select im_sooooo_impatient,
i_just_cant_delay
from so_when_someone_else_has_this
for update nowait;
drop table so_when_someone_else_has_this purge;