Saturday, June 12, 2010

ORACEL SQL.
How to List dates between two dates interval

select to_date('Start_date','dd-mm-yyyy') + rownum -1
from all_objects
where rownum <= to_date('End_date','dd-mm-yyyy')-to_date('Start_date','dd-mm-yyyy')+1

No comments:

Post a Comment