Re: For Loop w/time interval

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 18 Jun 2013 13:35:39 +0000 (UTC)
Message-ID: <kppnnb$qn1$1_at_solani.org>

On Mon, 17 Jun 2013 08:22:23 -0700, artmerar wrote:

> Hi,
>
> I need to write a FOR LOOP which uses minutes as the interval, from a
> start time to and end time.
>
> So, maybe something like this (pseudo english):
>
> For x IN (8:30 - 3:00 INTERVAL 1 minute) LOOP .
> .
> .
> END LOOP
>
> Where X will be the HH:MI that the loop is performing on. I'll need
> access to that HH:MI to compare it against other things.
>
> But, how to create the loop which will use the hour / minute?
>
> Thanks!

This should be facilitated using DBMS_LOCK.SLEEP routine, but it isn't as simple as that.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

Received on Tue Jun 18 2013 - 15:35:39 CEST