前辈们好，请教个问题，提前感谢。
如下图示，Oracle10g的环境，水果的销量数据，如何补充完整的日期档案？
即使那一天没有销量，也要显示出来。

下图中的写法，都不正确

with T1 as (
SELECT TO_CHAR(TO_DATE('2026-01-01', 'YYYY-MM-DD') + ROWNUM - 1, 'YYYY-MM-DD') as 日期
FROM DUAL
CONNECT BY ROWNUM <= TO_DATE('2026-01-14', 'YYYY-MM-DD') - TO_DATE('2026-01-01', 'YYYY-MM-DD') + 1
),
T2 as (
select '香蕉' as 水果,'2026-01-02' as 日期,1 as 销量 from dual
union all
select '香蕉','2026-01-04',2 from dual
union all
select '香蕉','2026-01-05',3 from dual
union all
select '香蕉','2026-01-08',4 from dual
union all
select '香蕉','2026-01-10',5 from dual
union all
select '香蕉','2026-01-12',6 from dual
union all
select '香蕉','2026-01-14',7 from dual

union all
select '桔子','2026-01-03',8 from dual
union all
select '桔子','2026-01-05',9 from dual
union all
select '桔子','2026-01-07',10 from dual
union all
select '桔子','2026-01-09',11 from dual
union all
select '桔子','2026-01-11',12 from dual
union all
select '桔子','2026-01-12',13 from dual
union all
select '桔子','2026-01-14',14 from dual
)
select T1.日期,T2.水果,T2.销量 from T1 left join T2 on T1.日期 = T2.日期 -- between '2026-01-01' and '2026-02-14'