Dates Generation between two Dates.sql

 Dates Generation between two Dates.sql

SELECT TO_DATE('12/Jan/2003', 'DD/Mon/YYYY') - 1 + rownum AS Dates
FROM all_objects
WHERE TO_DATE('12/Jan/2003', 'DD/Mon/YYYY') - 1 + rownum <= TO_DATE('12/Mar/2003', 'DD/Mon/YYYY');