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
Date: 1996/11/07
Message-ID: <55t5pe$583_at_nntp1.u.washington.edu>#1/1
I'd like to do the following:
LOOP
delay 5 seconds;
select...;
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