Oracle connect by level

生成全年日期

select to_date('20230101','YYYYMMDD') + LEVEL-1 from dual connect by level<366;