clear markdown compare help best fiddles feedback
clear markdown feedback
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
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
 hidden batch(es)