1       16:11:12  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2021030100:00:00
2       16:11:12  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2021030100:00:00
3       16:11:12  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2021032523:59:59
4       16:11:12  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2021032523:59:59
5       16:11:12  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 508.000000
6       16:11:12  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1107.000000
7       16:11:12  SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1107.000000
8       16:11:12  SQL Execute: ORACLE - select y.sl0000,y.je0000,y.XMDJ00,y.KJXMMC,y.xmmc00,g.zwxm00 zxrxm0,g.xkh000 from (select b.XMDJ00,sum(b.ZXSL00) sl0000, sum(b.HJJE00) je0000,kjxmmc,decode(grouping(b.zxr000),1,'总计:',decode(grouping(b.kjxmmc),1,'合计:',decode(grouping(b.xmmc00),1,b.kjxmmc||'小计:',b.XMMC00))) XMMC00,decode(grouping(b.zxr000),1,99,decode(grouping(b.kjxmmc),1,98,decode(grouping(b.xmmc00),1,97,96) )) XH0000,b.zxr000 from VW_YJ_GRSRCXTJ b    where b.zxrq00>=substr(?,1,8) and b.zxrq00||b.zxsj00>=?    and b.zxrq00||b.zxsj00<=? and b.zxrq00<=substr(?,1,8)    and b.zxks00+0=? and ( b.zxr000=? or ? = -1 )   group by rollup(b.zxr000,b.kjxmmc,b.XMMC00,b.XMDJ00)  having grouping(b.zxr000)=1 or grouping(b.XMMC00)=1 or grouping(b.XMDJ00)=0 ) y,bm_ygbm00 g where y.zxr000=g.ygbh00(+)  order by g.xkh000,g.zwxm00,decode(nvl(y.kjxmmc,3),'其他',2,3,3,1),y.kjxmmc,y.XH0000,y.xmmc00