date series

From: Jean <ken_jean_at_hotmail.com>
Date: Wed, 2 May 2001 12:47:59 +0200
Message-ID: <9coopd$70d$1@serv1.iunet.it>

Hi to all.
I'm developing a web application based on Oracle 8.i database I need a query that outputs date series betweet two dates. For example I have start date 01-05-2001 (DD-MM-YYYY) and end date

07-05-2001 (DD-MM-YYYY) and the query results must be
01-05-2001
02-05-2001
03-05-2001
04-05-2001
05-05-2001
06-05-2001
07-05-2001

I say that it can be possible using calendar functions but I'm not able to use it.
Can anyone help me?
All solutions is appreciated.
Thank a lot in advance.
Bye

JEAN Received on Wed May 02 2001 - 05:47:59 CDT