variable start_date varchar2(25)
variable end_date varchar2(25)

exec :start_date := '01-Jan-2009'; :end_date := '20-Jun-2009';

select to_date(:start_date,'dd-mon-yyyy') + rownum -1
from all_objects
where rownum <= to_date(:end_date,'dd-Mon-yyyy')-to_date(:start_date,'dd-Mon-yyyy')+1;