sql>var date_from varchar2(10)
sql>var date_to   varchar2(10)
sql>exec :date_from := '07/01/2003'; :date_to := '07/04/2003';
 
PL/SQL procedure successfully completed.
 
sql>select to_date(:date_from, 'mm/dd/yyyy') + rownum - 1 the_date
  2    from all_objects
  3   where rownum <= (to_date(:date_to, 'mm/dd/yyyy') - to_date(:date_from, 'mm/dd/yyyy') + 1);
 
THE_DATE
----------
07/01/2003
07/02/2003
07/03/2003
07/04/2003
 
4 rows selected.