select A.ID, A.START_DATE+delta dtfrom t_dates A, ( select level-1 as delta from dual connect by level-1 <= ( select max(end_date - start_date) from t_dates ) )where A.START_DATE+delta <= A.end_dateorder by 1, 2
select A.ID, A.START_DATE+delta dtfrom t_dates A, ( select level-1 as delta from dual connect by level-1 <= ( select max(end_date - start_date) from t_dates ) )where A.START_DATE+delta <= A.end_dateorder by 1, 2
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
