produce a list of dates?

[fengguangjin]

How to make a query to return a list of dates if given two dates? Say giving '12/16/2002' and '12/20/2002', I hope the dataset returns these five consecutive dates.

Thanks

Victor Feng

 

[toddbarry]

select :date1 + (rownum - 1)
  from all_objects
 where rownum <= (:date2 - :date1 + 1);

 

[fengguangjin]

Thanks! It's helpful.

Victor