Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> "SLEEP" command in PL/SQL?
Does anyone know if there's an equivalent of the unix "sleep" command
in PL/SQL? I've got a stored procedure that goes into a loop and
inserts a specified number of rows into a table. I'd like to have the
procedure insert a row every, say, three seconds. Is there a
relatively easy way to this?
I've already got a Korn shell script that loops and inserts a row every three seconds, but I'd like to do the whole thing in a stored procedure. Any ideas?
Thanks,
--Walt Weaver
Powerhouse Technologies
Bozeman, MT USA
Received on Fri May 01 1998 - 11:19:46 CDT
![]() |
![]() |