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);


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, 
from   so_when_someone_else_has_this
for update nowait;

drop table so_when_someone_else_has_this purge;

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>