将schoolday_DATE添加到第一个查询，然后根据DATE数据类型值将它们连接起来：

with
school_days AS
  (SELECT to_char(trunc(sysdate ,'D') + LEVEL - sw.LEV_1, 'dy') as school_day,
                  trunc(sysdate ,'D') + LEVEL - sw.LEV_1        as school_date
       FROM SCHOOL_WEEKS sw
    CONNECT BY LEVEL <= sw.LEV_2
  ),
all_dates AS 
  (SELECT to_char((sw.sc_start_date + LEVEL-1), 'DAY') as weekday_day,
                   sw.sc_start_date + LEVEL-1          as weekday_date           
      FROM SCHOOL_WEEKS sw
   CONNECT BY sw.sc_start_date + LEVEL-1 <=  sw.sc_end_date
  )
select a.*
from all_dates a join school_days s on s.school_date = a.weekday_day
order by a.weekday_date;