Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: [help!] is there sleep(or like sleep) function?
รยคยฟยตยปรณ wrote:
>
> hello
> is there sleep function ?
> i want pause a few seconds in procedure,
> but i can't find proper command. so i need help!!!!
> have nice day!
dbms_lock.sleep(n)
will sleep 'n' seconds.
HTH
-- =========================================== Connor McDonald http://www.oracledba.co.uk We are born naked, wet and hungry...then things get worseReceived on Mon Jun 26 2000 - 00:00:00 CDT