1 08:15:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %2% 2 08:15:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %2% 3 08:15:49 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '821155' ) Order By DWBH00,PY0000) where Rownum<=150 4 08:15:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %20% 5 08:15:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %20% 6 08:15:49 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '821155' ) Order By DWBH00,PY0000) where Rownum<=150 7 08:15:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %201% 8 08:15:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %201% 9 08:15:50 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '821155' ) Order By DWBH00,PY0000) where Rownum<=150 10 08:15:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %2012% 11 08:15:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %2012% 12 08:15:50 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ? or DWBH00 Like ?) and( YYID00 = '821155' ) Order By DWBH00,PY0000) where Rownum<=150 13 08:15:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = %2012n% 14 08:15:50 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '821155' ) Order By PY0000) where Rownum<=150 15 08:15:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = %2012nj% 16 08:15:51 SQL Execute: ORACLE - Select * from (select DWMC00,PY0000,WB0000,DWID00,DWTJCS,BRID00 from vw_TJ_TYDWB0 where (PY0000 Like ?) and( YYID00 = '821155' ) Order By PY0000) where Rownum<=150 17 08:15:53 SQL Execute: ORACLE - select SFJS00 from BM_TYDWB0 where DWID00=378 18 08:15:53 SQL Execute: ORACLE - select ZBMC00,DWZBID from VW_TJ_DWZB00 where DWID00='378' 19 08:15:53 SQL Execute: ORACLE - select distinct BMMC00 from BM_BRXXB0 where TYDWID='378' 20 08:15:53 SQL Execute: ORACLE - select z.je0000 je0000,z.zhje00 zhje00,(je0000 - zhje00) ZKE000,round(100*z.zhje00/decode(z.je0000,0,1,z.je0000),0) zkl000,z.FJF000 FJF000,z.rs0000,ROUND(z.dj0000,3) dj0000,z.zlxmid,s.zlxmjc xmmc00 from ( select sum(sl0000) rs0000,dj0000,sum(zje000) je0000,sum(zhje00) zhje00,sum(FJF000) FJF000,zlxmid from (select sl0000,jzje00-FJF000 zje000,round((jzje00-FJF000)*(zhje00/zje000),2) zhje00,fjf000,zlxmid,zje000/sl0000 dj0000 from ( select a.sl0000,sum(d.jzje00) jzje00,nvl(a.zje000,0) zje000,nvl(a.zhje00,0) zhje00,(select nvl(sum(jzje00),0) from yj_ywjj00 where yjdjh0=a.yjdjh0 and FJFYBZ='Y') FJF000,a.zlxmid from TJ_YJDJH0 a,tj_brxxb0 c,yj_ywjj00 d,bm_tydwb0 e where a.yjdjh0=d.yjdjh0 and c.dwid00=e.dwid00 and exists (select 1 from sf_brfy00 f,sf_fymx00 h where f.jzdh00+0=0 and f.djh000=h.djh000 and f.brid00=e.brid00 and h.yjdjh0=a.yjdjh0) and c.dwid00='378' and c.dwtjcs='1' and c.dwid00=a.dwid00 and a.ghid00=c.ghid00 and (not exists (select 'y' from tj_yjdjh0 t where t.cxdjh0=a.yjdjh0)) and ((a.cxdjh0=0) or (a.cxdjh0 is null)) and a.xmzt00 in ('2','3','D') and NVL(a.SFJZ00,'N')<>'Y' group by a.sl0000,a.zje000,a.zhje00,a.FJF000,a.zlxmid,a.yjdjh0,a.yjksbh)) y group by zlxmid,zhje00,fjf000,dj0000) z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid and (z.je0000<>0 or FJF000<>0) 21 08:15:53 SQL Error: ORACLE - ORA-01476: 除数为 0 22 08:15:53 SQL Error: ORACLE - Unmapped SQL Error Code: 1476 23 08:15:53 SQL Data In: ORACLE - Rows affected = 0 24 08:16:02 SQL Execute: ORACLE - select BRID00 from BM_TYDWB0 where DWID00='378' 25 08:16:02 SQL Execute: ORACLE - select MAX(MZID00) from SF_BRFY00 where BRID00=388344 26 08:16:02 SQL Execute: ORACLE - select * from (select JZDH00||'|'||JZRQ00 JZDHRQ,JZDH00,JZRQ00 from SF_JZB000 a,SF_PJSYQK b where a.BRID00=388344 and MZID00=1060994 and a.PJH000=b.PJH000 and b.SFDY00='Y' AND NOT EXISTS(SELECT 1 FROM SF_JZB000 WHERE CXJZDH = A.JZDH00 and pjh000=a.pjh000 ) ) order by JZRQ00 27 08:34:41 Log started for: 健康体检系统