ORACLE——查询某段时间内的每一天

SELECT to_date('2019-01-01', 'yyyy-MM-dd') + ROWNUM - 1 AS dateday 
FROM dual 
CONNECT BY ROWNUM <= (to_date('2021-08-24', 'yyyy-MM-dd') - to_date('2019-01-01', 'yyyy-MM-dd'))