By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601446 fiddles created (47986 in the last week).
with cte(dte) as (
select to_date('2020' || '8', 'YYYYMM')
from dual
union all
select dte + interval '1' day
from cte
where dte < last_day(dte)
)
select *
from cte
