Ask your code to wait

If for some reason you want for your code to wait for certain period of time, you can use dbms_lock.sleep(100); , in order to test this you can use the code below, from the test table you can see how much the code waited between the two insert statements. create table test (date1 date); begin insert into test values (sysdate); dbms_lock.sleep(100); insert into test values (sysdate); commit; end; select * from test;