根据已有的日历表，输入月份，查询该月每天属于星期几，结果展示成日历的样式

查询结果如下图：

实现sql如下：

with month as (

select t_date from calendar_table where substr(t_date,1,7) = substr(查询月份,1,7)

),

flag as (

select weekday(concat(substr(查询月份，1,7)，‘-01’))  tag

),

week_0 as(

select rownum num, tag from (

select case when 0<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 0

) where num is not null

),
week_1 as(

select rownum num, tag from (

select case when 1<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 1

) where num is not null

),
week_2 as(

select rownum num, tag from (

select case when 2<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 2

) where num is not null

),
week_3 as(

select rownum num, tag from (

select case when 3<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 3

) where num is not null

),
week_4 as(

select rownum num, tag from (

select case when 4<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 4

) where num is not null

),
week_5 as(

select rownum num, tag from (

select case when 5<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 5

) where num is not null

),
week_6 as(

select rownum num, tag from (

select case when 6<flag.tag then 1 else '' end as num, '' tag from flag

union

select rownum num, t_date || char(10) || '查询结果'  tag from month where (weekday(month.t_date)) = 6

) where num is not null

)

select week_0.tag 星期天,week_1.tag 星期一, week_2.tag 星期二, week_3.tag 星期三, week_4.tag 星期四, week_5.tag 星期五, week_6.tag 星期六
from week_0
left join week_1 on week_0.num = week_1.num
left join week_2 on week_0.num = week_2.num
left join week_3 on week_0.num = week_3.num
left join week_4 on week_0.num = week_4.num
left join week_5 on week_0.num = week_5.num
left join week_6 on week_0.num = week_6.num