select to_date(to_char(v_start_date + (t.rn-1), 'yyyy-mm-dd'),'yyyy-mm-dd') as train_date
from (select rownum as rn from hr_user
where rownum <= ((v_end_date-v_start_date)+1)) t
from (select rownum as rn from hr_user
where rownum <= ((v_end_date-v_start_date)+1)) t