如何将表一数据通过sql变成表二的数据形式
with temp as ( select to_date('2020-01-01','yyyy-MM-dd') as starttime,to_date('2020-01-05','yyyy-MM-dd') as endtime from dual ) select starttime+rownum-1 as rq from temp connect by rownum<=endtime-starttime+1