select
to_char(to_date('20210801', 'yyyy-mm-dd') + level - 1, 'yyyy-mm-dd') dat
from dual
connect by level <= to_date('20210807', 'yyyy-mm-dd') -
to_date('20210801', 'yyyy-mm-dd') + 1;
输出:
2021-08-01
2021-08-02
2021-08-03
2021-08-04
2021-08-05
2021-08-06
2021-08-07