Delay by Specified Number of Seconds

[DarkAngel]

I created a table that will generate record numbers using an Oracle sequence (increment by 1). There is a date field in the record (Oracle DATE type). Is there a way to delay the time in the DATE field by a few seconds (between each transaction)?

I thought about using a PAUSE, but would like to avoid keyboard interaction. I will be adding records with an *.sql script.

Thanks,
D.A.

 

[sem]

Try to use dbms_lock.sleep procedure.