回答:var t1 = c.replace(/-/g, '');
回答: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.MONTHVIEWfrom(SELECT lpad(t.month,2,0) as FMONTH, t.month || '月实际产量' as MONTHVIEWFROM(select level month from dual connect by LEVEL <13)t)t,( select * from year where (1=1) ${if(len(pv2) = 0,"","and YEAR='" +pv2+ "'")}) awhere (1=1) t.FMONTH<=a.PD
回答:数据集对应的库名未更换
回答:有空值
回答:不让操作
回答:我没有切数据源
回答:还是sql执行太慢了,要改sql
回答:and (case when NVL(g.WORKLOTNO,'1') = '1' or NVL(t.WORKLOTNO,'1') = '1' then 1 else INSTR(g.WORKLOTNO,t.WORKLOTNO) end)>0and (case when NVL(g.WORKNO,'1') = '1' or NVL(t.WORKNO,'1') = '1' then 1 else INSTR(g.WORKNO,t.WORKNO) end)>0
回答:自己已解决
回答:不使用组内分栏,不太好使
14
14
216
10