Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to delay the execution of an SQL statement?

Re: How to delay the execution of an SQL statement?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 30 Apr 2002 06:46:58 +0200
Message-ID: <ucs9l21339lp1c@corp.supernews.com> 






"Anirban" <anirbanchanda_at_indiatimes.com> wrote in message
news:779a8bfa.0204292039.141421af_at_posting.google.com...


> I want to delay the execution of an SQL statement in a PL/SQL block.

> Is there any function like 'wait' or 'delay' which will delay the

> query?




dbms_lock.sleep(<n seconds>)



Hth


--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address


Received on Mon Apr 29 2002 - 23:46:58 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US