How to delay a sql statement in PL/SQL block

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1996/11/07
Message-ID: <55t5pe$583_at_nntp1.u.washington.edu>#1/1

I'd like to do the following:

  LOOP [Quoted]      delay 5 seconds;

[Quoted] [Quoted]      select...;
[Quoted]      delete ...;
     update...;

  END LOOP; Does anyone know how to implement this? I noticed 'DELAY' is a reserved word in PL/SQL but could not find any info about it. Is this the right one to use and how? Thanks,

Leslie Received on Thu Nov 07 1996 - 00:00:00 CET