with year as(

   SELECT

   a.YEAR,

CASE WHEN a.YEAR = TO_CHAR(SYSDATE,'YYYY') THEN SUBSTR(TO_CHAR(SYSDATE,'YYYY-MM'), 6, 2) else '12' end as pd

FROM

(select to_char(sysdate,'YYYY')-LEVEL+1 YEAR FROM DUAL CONNECT BY LEVEL<=13)a

)

select

  t.FMONTH,

t.MONTHVIEW

from

(SELECT

 lpad(t.month,2,0) as FMONTH,

 t.month || '月实际产量' as MONTHVIEW

FROM

(select level month from dual connect by LEVEL <13)t

)t,

(

  select * from year 

where (1=1)

        ${if(len(pv2) = 0,"","and YEAR='" +pv2+ "'")}

) a

where (1=1)

  t.FMONTH<=a.PD