N dates on the go from DUAL



select * from (select TO_DATE ( '1-feb-04') + level from dual connect by level < 100)

Links

• Syndicate this site