By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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
| DTE |
|---|
| 01-AUG-20 |
| 02-AUG-20 |
| 03-AUG-20 |
| 04-AUG-20 |
| 05-AUG-20 |
| 06-AUG-20 |
| 07-AUG-20 |
| 08-AUG-20 |
| 09-AUG-20 |
| 10-AUG-20 |
| 11-AUG-20 |
| 12-AUG-20 |
| 13-AUG-20 |
| 14-AUG-20 |
| 15-AUG-20 |
| 16-AUG-20 |
| 17-AUG-20 |
| 18-AUG-20 |
| 19-AUG-20 |
| 20-AUG-20 |
| 21-AUG-20 |
| 22-AUG-20 |
| 23-AUG-20 |
| 24-AUG-20 |
| 25-AUG-20 |
| 26-AUG-20 |
| 27-AUG-20 |
| 28-AUG-20 |
| 29-AUG-20 |
| 30-AUG-20 |
| 31-AUG-20 |