1 08:35:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 340 2 08:35:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BT 3 08:35:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ZKCL 4 08:35:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 5 08:35:02 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 6 08:35:02 SQL Execute: ORACLE - select distinct zkbbph from jy_zkjg00 where yqdh00='BT' and zxrq00 between '20170901' and '20170919' 7 08:35:02 SQL Execute: ORACLE - select YBH000,ZKBBPH from JY_ZLKZBB where YQDH00='BT' and ZKBBPH='45732' 8 08:35:02 SQL Execute: ORACLE - select JXCS00 from JY_SJRKB0 a,JY_SJB000 b where a.SJBH00=b.SJBH00 and b.YQDH00='BT' 9 08:35:02 SQL Execute: ORACLE - select YQDH00,ZKBBPH,YBH000,BGXMID,ZWMC00,DYSX00, (select ZKJG00 from jy_zkjg00 where sfyx00='Y' and zkbbph=a.zkbbph and YBH000=a.ybh000 and zxrq00=to_char(sysdate,'YYYYMMDD') and bgxmid=a.bgxmid and rownum=1) DTZKJG, (select decode(SFSK00,'Y',sign(zkjg00-DYBZ00)) from jy_zkjg00 where sfyx00='Y' and zkbbph=a.zkbbph and YBH000=a.ybh000 and zxrq00=to_char(sysdate,'YYYYMMDD') and bgxmid=a.bgxmid and rownum=1) SFSK00 from ( select distinct YQDH00,ZKBBPH,YBH000,BGXMID,ZWMC00,DYSX00 from (select YQDH00,ZKBBPH,YBH000,BGXMID,ZWMC00,DYSX00 from VW_JY_ZKJG00 where YQDH00 = 'BT' and ZKBBPH = '45732' and YBH000 = 'BT'||'0999' and ZXRQ00 >= '20170901' and ZXRQ00 <= '20170919' ) order by DYSX00) A 10 08:35:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BT0999 11 08:35:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 45732 12 08:35:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3588 13 08:35:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BT 14 08:35:02 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170901 15 08:35:02 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170919 16 08:35:02 SQL Execute: ORACLE - select * from vw_jy_ZKJG00_new where ybh000=? and ZKBBPH=? and bgxmid=? and YQDH00=? and ZXRQ00 between ? and ? order by zxrq00,XH0000 17 08:35:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BT0999 18 08:35:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 45732 19 08:35:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3588 20 08:35:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BT 21 08:35:02 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170901 22 08:35:02 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170919 23 08:35:02 SQL Execute: ORACLE - select * from vw_jy_ZKJG00 where ybh000=? and ZKBBPH=? and bgxmid=? and YQDH00=? and ZXRQ00 between ? and ? order by zxrq00,XH0000 24 08:35:02 SQL Execute: ORACLE - select ZKJG00,DYBZ00,DYBZC0 from jy_ZKJG00 where ybh000='BT0999' and ZKBBPH='45732' and bgxmid='3588' and YQDH00='BT' and zkjg00 is not null and sfyx00='Y' AND ZXRQ00 between '20170901' and '20170919' ORDER BY ZXRQ00,XH0000 25 08:35:03 SQL Execute: ORACLE - select ZKJG00,ROWNUM from jy_ZKJG00 where ybh000='BT0999' and ZKBBPH='45732' and bgxmid='3588' and YQDH00='BT' and zkjg00 is not null and sfyx00='Y' AND ZXRQ00 between '20170901' and '20170919' ORDER BY ZXRQ00 26 08:35:03 SQL Execute: ORACLE - select count(*) rowCount from vw_jy_ZKJG00_new where ybh000='BT0999' and ZKBBPH='45732' and bgxmid='3588' and YQDH00='BT' and zkjg00 is not null AND ZXRQ00 between '20170901' and '20170919' 27 08:35:03 SQL Data In: ORACLE - Param = 1, Name = PZKBBPH, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 45732 28 08:35:03 SQL Data In: ORACLE - Param = 2, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = BT0999 29 08:35:03 SQL Data In: ORACLE - Param = 3, Name = PBGXMID, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3588 30 08:35:03 SQL Data In: ORACLE - Param = 4, Name = PKSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170901 31 08:35:03 SQL Data In: ORACLE - Param = 5, Name = PJSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170919 32 08:35:03 SQL Data In: ORACLE - Param = 6, Name = PZKGZSM, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 08:35:03 SQL Execute: ORACLE - BEGIN "SP_JY_ZKGZPD" (PZKBBPH => :PZKBBPH,PYBH000 => :PYBH000,PBGXMID => :PBGXMID,PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PZKGZSM => :PZKGZSM); END; 34 08:35:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BT0999 35 08:35:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 45732 36 08:35:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3588 37 08:35:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BT 38 08:35:03 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170901 39 08:35:03 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170919 40 08:35:03 SQL Execute: ORACLE - select * from vw_jy_ZKJG00_new where ybh000=? and ZKBBPH=? and bgxmid=? and YQDH00=? and ZXRQ00 between ? and ? order by zxrq00,XH0000 41 08:35:04 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 42 08:35:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BT0999 43 08:35:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 45732 44 08:35:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3616 45 08:35:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BT 46 08:35:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170901 47 08:35:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170919 48 08:35:05 SQL Execute: ORACLE - select * from vw_jy_ZKJG00_new where ybh000=? and ZKBBPH=? and bgxmid=? and YQDH00=? and ZXRQ00 between ? and ? order by zxrq00,XH0000 49 08:35:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BT0999 50 08:35:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 45732 51 08:35:05 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3616 52 08:35:05 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BT 53 08:35:05 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170901 54 08:35:05 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170919 55 08:35:05 SQL Execute: ORACLE - select * from vw_jy_ZKJG00 where ybh000=? and ZKBBPH=? and bgxmid=? and YQDH00=? and ZXRQ00 between ? and ? order by zxrq00,XH0000 56 08:35:05 SQL Execute: ORACLE - select ZKJG00,DYBZ00,DYBZC0 from jy_ZKJG00 where ybh000='BT0999' and ZKBBPH='45732' and bgxmid='3616' and YQDH00='BT' and zkjg00 is not null and sfyx00='Y' AND ZXRQ00 between '20170901' and '20170919' ORDER BY ZXRQ00,XH0000 57 08:35:14 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 58 09:00:22 Log started for: SQL Navigator for Oracle 59 10:16:21 Log started for: 住院医生工作站系统 60 10:16:23 Log started for: SQL Navigator for Oracle 61 10:16:39 Log started for: 住院医生工作站系统 62 10:17:08 Log started for: SQL Navigator for Oracle 63 10:55:48 Log started for: 检验信息系统 64 10:55:52 Log started for: SQL Navigator for Oracle