Generating List of date from specific range date

SELECT TO_CHAR ( TO_DATE(:start_date,'dd-mon-yyyy') + ROWNUM -1 , 'DY' )
FROM ALL_OBJECTS
WHERE ROWNUM <=
TO_DATE(:end_date,'dd-mon-yyyy')-TO_DATE(:start_date,'dd-mon-yyyy')+1
GROUP BY TO_CHAR ( TO_DATE(:start_date,'dd-mon-yyyy') + ROWNUM -1 , 'DY' ) ;

Taken From http://asktom.oracle.com