1 10:56:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211001 2 10:56:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211028 3 10:56:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211001 4 10:56:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211028 5 10:56:26 SQL Execute: ORACLE - select * from (select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.JZDW00,a.CRRQSJ,a.RCLXMC,a.RKGJDJ,a.SLDJ00,a.SLSL00,a.GJSLJE,a.SLJE00,a.CKGJDJ,a.FCDJ00,a.FCSL00,a.GJFCJE,a.FCJE00,a.JCSLXX,a.DJH000,a.SHF000,a.FHF000,a.JZXZ00,a.JZRQ00,a.JZSJ00,1 HJJLS0,a.GJSLJE HJGJSL,a.SLJE00 HJSLJE,a.GJFCJE HJGJFC,a.FCJE00 HJFCJE,b.TXM000,a.CZFLMC,a.PFDJ00,a.PFJE00,a.GJBZBM,a.GJBZMC from VW_YK_YPMXZ0 a,BM_YD0000 b where a.YKBMBH+0=2279 and a.JZRQ00 between ? and ? and a.YPNM00=b.YPNM00 union all select a.YPNM00,a.YPBM00,' 小计:' as YPMC00,to_char(count(1))||'条' as YPGG00,NULL JZDW00,NULL CRRQSJ,NULL RCLXMC,NULL RKGJDJ,NULL SLDJ00,sum(a.SLSL00) SLSL00,sum(a.GJSLJE) GJSLJE,sum(a.SLJE00) SLJE00,NULL CKGJDJ,NULL FCDJ00,sum(a.FCSL00) FCSL00,sum(a.GJFCJE) GJFCJE,sum(a.FCJE00) FCJE00,NULL JCSLXX,NULL DJH000,NULL SHF000,NULL FHF000,NULL JZXZ00,NULL JZRQ00,NULL JZSJ00,0 HJJLS0,0 HJGJSL,0 HJSLJE,0 HJGJFC,0 HJFCJE,b.TXM000 TXM000,a.CZFLMC,null PFDJ00,sum(a.PFJE00) PFJE00,a.GJBZBM,a.GJBZMC from VW_YK_YPMXZ0 a,BM_YD0000 b where a.YKBMBH+0=2279 and a.JZRQ00 between ? and ? and a.YPNM00=b.YPNM00 group by a.YPNM00,a.YPBM00,b.TXM000,a.CZFLMC,,a.GJBZBM,a.GJBZMC) order by YPBM00,JZRQ00,JZSJ00 6 10:56:26 SQL Error: ORACLE - ORA-00936: 缺失表达式 7 10:56:26 SQL Error: ORACLE - Unmapped SQL Error Code: 936 8 10:56:26 SQL Data In: ORACLE - Rows affected = 0