1 13:44:40 SQL Execute: ORACLE - select A.*,0 flag00,substrb(SF_ZY_RQDXX0(a.zyid00,a.QDH000,null),1,200) qdfjxx from VW_BQ_RQD000 A where 1 = 1 and A.DBZBM0 is null and A.RYBQ00+0=56 and A.CZRQ00 >= '20200831' and A.CZRQ00 < '20200904' and exists(select 1 from ZY_BRXXB0 where ZYID00=a.ZYID00 and substr(BRZT00,1,1)='2') order by a.rycwh0,a.qdh000 2 13:44:41 SQL Execute: ORACLE - select * from ( select xmmc00,xmdj00,sum(xmsl00)xmsl00,xmgg00,xmdw00,sum(hjje00) hjje00,bh0000,xmbh00,zfbl00,zxksmc,gjbm00,gjbmzx,jsxm00 from VW_BQ_RQDMX4 where qdh000 between '20200831' and '20200903' and zyh000='' and zyid00= group by xmmc00,xmdj00,xmdw00,bh0000,xmbh00,xmgg00,zfbl00,zxksmc,gjbm00,gjbmzx,jsxm00) where xmsl00<>0 order by gjbmzx,jsxm00,gjbm00 3 13:44:41 SQL Error: ORACLE - ORA-00936: 缺失表达式 4 13:44:41 SQL Error: ORACLE - Unmapped SQL Error Code: 936 5 13:44:41 SQL Data In: ORACLE - Rows affected = 0 6 13:44:45 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=56 or DQKS00=56) order by XXID00 7 13:51:47 Log started for: Sickberth00 8 13:52:29 SQL Execute: ORACLE - select A.*,0 flag00,substrb(SF_ZY_RQDXX0(a.zyid00,a.QDH000,null),1,200) qdfjxx from VW_BQ_RQD000 A where 1 = 1 and A.DBZBM0 is null and A.RYBQ00+0=56 and A.ZYH000 = '0227007' and A.CZRQ00 >= '20200831' and A.CZRQ00 < '20200901' order by a.rycwh0,a.qdh000 9 13:52:30 SQL Execute: ORACLE - select * from ( select xmmc00,xmdj00,sum(xmsl00)xmsl00,xmgg00,xmdw00,sum(hjje00) hjje00,bh0000,xmbh00,zfbl00,zxksmc,gjbm00,gjbmzx,jsxm00 from VW_BQ_RQDMX4 where qdh000 between '20200831' and '20200831' and zyh000='' and zyid00= group by xmmc00,xmdj00,xmdw00,bh0000,xmbh00,xmgg00,zfbl00,zxksmc,gjbm00,gjbmzx,jsxm00) where xmsl00<>0 order by gjbmzx,jsxm00,gjbm00 10 13:52:30 SQL Error: ORACLE - ORA-00936: 缺失表达式 11 13:52:30 SQL Error: ORACLE - Unmapped SQL Error Code: 936 12 13:52:30 SQL Data In: ORACLE - Rows affected = 0 13 13:52:36 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=56 or DQKS00=56) order by XXID00 14 13:52:46 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=56 or DQKS00=56) order by XXID00