Generating Dates between two date ranges Oracle

Publicada el mayo 24, 2019 por Victor Hugo Choc Cac

select to_char(trunc(to_date(20190822,’YYYYMMDD’),’MM’),’YYYYMMDD’)-1 + level as Date1,
to_char(to_date(to_char(trunc(to_date(20190822,’YYYYMMDD’),’MM’),’YYYYMMDD’),’YYYYMMDD’)-2 + level,’YYYYMMDD’) as Date2
from dual
connect by level <= to_char(last_day(to_date(20190822,’YYYYMMDD’)),’DD’)
order by Date1;