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;

 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>

(required)

(required)