1 11:04:28 Log started for: 药房管理系统 2 11:04:28 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:04:28','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 11:04:28 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:04:28','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 11:04:28 SQL Data In: ORACLE - Rows affected = 1 5 11:04:28 SQL Prepare: ORACLE - Commit 6 11:04:28 SQL Execute: ORACLE - Commit 7 11:04:28 SQL Data In: ORACLE - Rows affected = 0 8 11:04:28 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 11:04:28 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 11:04:28 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 11 11:04:28 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 12 11:04:28 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:04:28','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 13 11:04:28 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:04:28','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 14 11:04:28 SQL Data In: ORACLE - Rows affected = 1 15 11:04:28 SQL Prepare: ORACLE - Commit 16 11:04:28 SQL Execute: ORACLE - Commit 17 11:04:28 SQL Data In: ORACLE - Rows affected = 0 18 11:04:28 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 19 11:04:28 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 20 11:04:28 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 21 11:04:28 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 22 11:04:28 SQL Prepare: ORACLE - Select SYSDATE from Dual 23 11:04:28 SQL Execute: ORACLE - Select SYSDATE from Dual 24 11:04:28 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 25 11:04:28 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 26 11:04:28 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 27 11:04:28 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 28 11:04:28 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 11:04:28 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 11:04:28 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 31 11:04:28 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 32 11:04:28 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 33 11:04:28 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 34 11:04:28 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 35 11:04:28 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 36 11:04:31 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 37 11:04:31 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 38 11:04:31 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 39 11:04:31 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 40 11:04:31 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 41 11:04:31 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 42 11:04:31 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 43 11:04:31 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 44 11:04:31 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 45 11:04:31 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 46 11:04:31 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 47 11:04:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 48 11:04:31 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 49 11:04:31 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 50 11:04:31 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874082,476,'wlzx-2','2',nvl('321034',' '),'192.168.13.206#730:10907@appYP_YF.exe+药房管理系统',45) 51 11:04:31 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874082,476,'wlzx-2','2',nvl('321034',' '),'192.168.13.206#730:10907@appYP_YF.exe+药房管理系统',45) 52 11:04:31 SQL Data In: ORACLE - Rows affected = 1 53 11:04:31 SQL Prepare: ORACLE - Commit 54 11:04:31 SQL Execute: ORACLE - Commit 55 11:04:31 SQL Data In: ORACLE - Rows affected = 0 56 11:04:31 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 57 11:04:31 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 58 11:04:31 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 59 11:04:31 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 60 11:04:31 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 61 11:04:31 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 62 11:04:31 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 63 11:04:31 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 64 11:04:31 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 65 11:04:31 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 66 11:04:31 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090904' 67 11:04:31 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090904' 68 11:04:31 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 69 11:04:31 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 70 11:04:31 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 71 11:04:31 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 72 11:04:31 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 73 11:04:31 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 74 11:04:31 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 75 11:04:31 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 76 11:04:31 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 77 11:04:31 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 78 11:04:31 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 79 11:04:31 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 80 11:04:31 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 81 11:04:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 82 11:04:31 SQL Prepare: ORACLE - select * from XT_XTCS00 83 11:04:31 SQL Execute: ORACLE - select * from XT_XTCS00 84 11:04:33 SQL Prepare: ORACLE - select * from BM_YPLB00 85 11:04:33 SQL Execute: ORACLE - select * from BM_YPLB00 86 11:04:33 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 87 11:04:33 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 88 11:04:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 89 11:04:33 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 90 11:04:33 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 91 11:04:33 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 92 11:04:33 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 93 11:04:33 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 94 11:04:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 95 11:04:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 96 11:04:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 97 11:04:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 98 11:04:33 SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 99 11:04:33 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 100 11:04:33 SQL Prepare: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 101 11:04:33 SQL Execute: ORACLE - SELECT B.BMBH00,B.BMMC00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 102 11:04:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 103 11:04:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 104 11:04:33 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=45 AND YKKCSL'0' 105 11:04:33 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=45 AND YKKCSL'0' 106 11:04:35 SQL Prepare: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=45 and X.SFQR00='N' and T.SFQR00='Y' 107 11:04:35 SQL Execute: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=45 and X.SFQR00='N' and T.SFQR00='Y' 108 11:04:43 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 109 11:04:43 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 110 11:04:53 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 111 11:04:53 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 112 11:05:03 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 113 11:05:03 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 114 11:05:13 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 115 11:05:13 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 116 11:05:23 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 117 11:05:23 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 118 11:05:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 119 11:05:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 120 11:05:43 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 121 11:05:43 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 122 11:05:53 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 123 11:05:53 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 124 11:06:03 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 125 11:06:03 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 126 11:06:07 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 127 11:06:07 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 128 11:06:07 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 129 11:06:07 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 130 11:06:07 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 131 11:06:07 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 132 11:06:07 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 133 11:06:07 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 134 11:06:07 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 135 11:06:07 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 136 11:06:07 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 137 11:06:07 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 138 11:06:07 SQL Prepare: ORACLE - select * from BM_YPLB00 139 11:06:07 SQL Execute: ORACLE - select * from BM_YPLB00 140 11:06:07 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 141 11:06:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 142 11:06:07 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 143 11:06:07 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 144 11:06:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 145 11:06:07 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 146 11:06:07 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 147 11:06:07 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 148 11:06:10 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 149 11:06:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 150 11:06:10 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 151 11:06:10 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 152 11:06:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 153 11:06:10 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 154 11:06:30 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:06:29','scott@3311:338F713E2529E9C8839C1769C719ABF0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 155 11:06:30 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:06:29','scott@3311:338F713E2529E9C8839C1769C719ABF0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 156 11:06:30 SQL Data In: ORACLE - Rows affected = 1 157 11:06:30 SQL Prepare: ORACLE - Commit 158 11:06:30 SQL Execute: ORACLE - Commit 159 11:06:30 SQL Data In: ORACLE - Rows affected = 0 160 11:06:30 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 161 11:06:30 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 162 11:06:30 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3311' and CZBZ00 in ('1') 163 11:06:30 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='3311' and CZBZ00 in ('1') 164 11:06:30 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:06:29','sd_Hospital@3311:7DC30EF70C0F002EA5F4E4C471347176' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 165 11:06:30 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:06:29','sd_Hospital@3311:7DC30EF70C0F002EA5F4E4C471347176' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 166 11:06:30 SQL Data In: ORACLE - Rows affected = 1 167 11:06:30 SQL Prepare: ORACLE - Commit 168 11:06:30 SQL Execute: ORACLE - Commit 169 11:06:30 SQL Data In: ORACLE - Rows affected = 0 170 11:06:30 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 171 11:06:30 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 172 11:06:30 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3311' and CZBZ00 in ('1') 173 11:06:30 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3311' and CZBZ00 in ('1') 174 11:06:30 SQL Prepare: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 175 11:06:30 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 176 11:06:30 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3311')) order by BH0000 177 11:06:30 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3311')) order by BH0000 178 11:06:30 SQL Prepare: ORACLE - Select '00' as XTDM00 from dual where '3311'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3311')) 179 11:06:30 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '3311'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='3311')) 180 11:06:30 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=341 181 11:06:30 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=341 182 11:06:30 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 183 11:06:30 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 184 11:06:30 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874082 185 11:06:30 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874082 186 11:06:30 SQL Data In: ORACLE - Rows affected = 1 187 11:06:30 SQL Prepare: ORACLE - Commit 188 11:06:30 SQL Execute: ORACLE - Commit 189 11:06:30 SQL Data In: ORACLE - Rows affected = 0 190 11:06:30 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 191 11:06:30 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 192 11:06:30 SQL Data In: ORACLE - Rows affected = 0 193 11:06:30 SQL Prepare: ORACLE - Commit 194 11:06:30 SQL Execute: ORACLE - Commit 195 11:06:30 SQL Data In: ORACLE - Rows affected = 0 196 11:06:31 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 197 11:06:31 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 198 11:06:31 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 199 11:06:31 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 200 11:06:31 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 201 11:06:31 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 202 11:06:31 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 203 11:06:31 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 204 11:06:31 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 205 11:06:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 206 11:06:31 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 207 11:06:31 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 208 11:06:31 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874086,341,'wlzx-2','2',nvl('321042',' '),'192.168.13.206#620:5054@appYP_YF.exe+药房管理系统',45) 209 11:06:31 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874086,341,'wlzx-2','2',nvl('321042',' '),'192.168.13.206#620:5054@appYP_YF.exe+药房管理系统',45) 210 11:06:31 SQL Data In: ORACLE - Rows affected = 1 211 11:06:31 SQL Prepare: ORACLE - Commit 212 11:06:31 SQL Execute: ORACLE - Commit 213 11:06:31 SQL Data In: ORACLE - Rows affected = 0 214 11:06:31 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 215 11:06:31 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 216 11:06:31 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 217 11:06:31 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 218 11:06:31 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090904' 219 11:06:31 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090904' 220 11:06:31 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 221 11:06:31 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 222 11:06:31 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 223 11:06:31 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 224 11:06:31 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874086 225 11:06:31 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874086 226 11:06:31 SQL Data In: ORACLE - Rows affected = 1 227 11:06:31 SQL Prepare: ORACLE - Commit 228 11:06:31 SQL Execute: ORACLE - Commit 229 11:06:31 SQL Data In: ORACLE - Rows affected = 0 230 11:06:31 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 231 11:06:31 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 232 11:06:31 SQL Data In: ORACLE - Rows affected = 0 233 11:06:31 SQL Prepare: ORACLE - Commit 234 11:06:31 SQL Execute: ORACLE - Commit 235 11:06:31 SQL Data In: ORACLE - Rows affected = 0 236 11:06:31 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 237 11:06:31 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 238 11:06:31 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 239 11:06:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 240 11:06:31 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 241 11:06:31 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 242 11:06:31 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874087,341,'wlzx-2','2',nvl('321042',' '),'192.168.13.206#620:5054@appYP_YF.exe+药房管理系统',45) 243 11:06:31 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874087,341,'wlzx-2','2',nvl('321042',' '),'192.168.13.206#620:5054@appYP_YF.exe+药房管理系统',45) 244 11:06:31 SQL Data In: ORACLE - Rows affected = 1 245 11:06:31 SQL Prepare: ORACLE - Commit 246 11:06:31 SQL Execute: ORACLE - Commit 247 11:06:31 SQL Data In: ORACLE - Rows affected = 0 248 11:06:31 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 249 11:06:31 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 250 11:06:31 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 251 11:06:31 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 252 11:06:31 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 253 11:06:31 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 254 11:06:31 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 255 11:06:31 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 256 11:06:31 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 257 11:06:31 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 258 11:06:31 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 259 11:06:31 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 260 11:06:31 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 261 11:06:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 262 11:06:31 SQL Prepare: ORACLE - select * from XT_XTCS00 263 11:06:31 SQL Execute: ORACLE - select * from XT_XTCS00 264 11:06:32 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 265 11:06:32 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 266 11:06:32 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 267 11:06:32 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 268 11:06:32 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 269 11:06:32 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 270 11:06:32 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 271 11:06:32 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 272 11:06:32 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 273 11:06:32 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 274 11:06:32 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 275 11:06:32 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 276 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 277 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 278 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 279 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 280 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 281 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 282 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 283 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 284 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 285 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 286 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 287 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 288 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 289 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 290 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 291 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 292 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 293 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 294 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 295 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 296 11:06:33 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 297 11:06:33 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' ORDER BY B.BH0000 298 11:06:33 SQL Prepare: ORACLE - select * from BM_YPLB00 299 11:06:33 SQL Execute: ORACLE - select * from BM_YPLB00 300 11:06:33 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=341 301 11:06:33 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=341 302 11:06:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 303 11:06:33 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 304 11:06:33 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 305 11:06:33 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 306 11:06:33 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 307 11:06:33 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 308 11:06:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 309 11:06:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 310 11:06:33 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 311 11:06:33 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 341= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 312 11:06:34 SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 313 11:06:34 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 314 11:06:35 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 315 11:06:35 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 316 11:06:35 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 317 11:06:35 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 318 11:06:35 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 319 11:06:35 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 320 11:06:36 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 321 11:06:36 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 322 11:06:36 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 323 11:06:36 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 324 11:06:36 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 325 11:06:36 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 326 11:06:36 SQL Prepare: ORACLE - select * from BM_YPLB00 327 11:06:36 SQL Execute: ORACLE - select * from BM_YPLB00 328 11:06:36 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 329 11:06:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 330 11:06:36 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 331 11:06:36 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 332 11:06:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 333 11:06:36 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 334 11:06:36 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 335 11:06:36 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 336 11:06:36 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 337 11:06:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 338 11:06:36 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 339 11:06:36 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 340 11:06:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 341 11:06:36 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 342 11:06:51 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 343 11:06:51 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 344 11:06:52 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 345 11:06:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 346 11:06:52 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 347 11:06:52 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 348 11:06:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 349 11:06:52 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 350 11:07:17 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 351 11:07:17 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 352 11:07:17 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 353 11:07:17 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 354 11:07:17 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 355 11:07:17 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 356 11:07:17 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 357 11:07:17 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 358 11:07:17 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 359 11:07:17 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 360 11:07:17 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 361 11:07:17 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 362 11:07:17 SQL Prepare: ORACLE - select * from BM_YPLB00 363 11:07:17 SQL Execute: ORACLE - select * from BM_YPLB00 364 11:07:17 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 365 11:07:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 366 11:07:17 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 367 11:07:17 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 368 11:07:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 369 11:07:17 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 370 11:07:17 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 371 11:07:17 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 372 11:07:19 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 373 11:07:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 374 11:07:19 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 375 11:07:19 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 376 11:07:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 377 11:07:19 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 378 11:07:53 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 379 11:07:53 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 380 11:07:53 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 381 11:07:53 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 382 11:07:53 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 383 11:07:53 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 384 11:07:53 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 385 11:07:53 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 386 11:07:53 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 387 11:07:53 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=341)))) 388 11:07:53 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 389 11:07:53 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 390 11:07:53 SQL Prepare: ORACLE - select * from BM_YPLB00 391 11:07:53 SQL Execute: ORACLE - select * from BM_YPLB00 392 11:07:53 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 393 11:07:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 394 11:07:53 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 395 11:07:53 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 396 11:07:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 397 11:07:53 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 398 11:07:53 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 399 11:07:53 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 400 11:07:55 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 401 11:07:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 402 11:07:55 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 403 11:07:55 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 404 11:07:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 405 11:07:55 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 406 11:08:13 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:08:12','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 407 11:08:13 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:08:12','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 408 11:08:13 SQL Data In: ORACLE - Rows affected = 1 409 11:08:13 SQL Prepare: ORACLE - Commit 410 11:08:13 SQL Execute: ORACLE - Commit 411 11:08:13 SQL Data In: ORACLE - Rows affected = 0 412 11:08:13 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 413 11:08:13 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 414 11:08:13 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 415 11:08:13 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 416 11:08:13 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:08:12','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 417 11:08:13 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20090904','11:08:12','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 418 11:08:13 SQL Data In: ORACLE - Rows affected = 1 419 11:08:13 SQL Prepare: ORACLE - Commit 420 11:08:13 SQL Execute: ORACLE - Commit 421 11:08:13 SQL Data In: ORACLE - Rows affected = 0 422 11:08:13 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 423 11:08:13 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 424 11:08:13 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 425 11:08:13 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 426 11:08:13 SQL Prepare: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 427 11:08:13 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 428 11:08:13 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 429 11:08:13 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('2','3') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 430 11:08:16 SQL Prepare: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 431 11:08:16 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 432 11:08:16 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 433 11:08:16 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 434 11:08:16 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 435 11:08:16 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 436 11:08:16 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874087 437 11:08:16 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874087 438 11:08:16 SQL Data In: ORACLE - Rows affected = 1 439 11:08:16 SQL Prepare: ORACLE - Commit 440 11:08:16 SQL Execute: ORACLE - Commit 441 11:08:16 SQL Data In: ORACLE - Rows affected = 0 442 11:08:16 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 443 11:08:16 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 444 11:08:16 SQL Data In: ORACLE - Rows affected = 0 445 11:08:16 SQL Prepare: ORACLE - Commit 446 11:08:16 SQL Execute: ORACLE - Commit 447 11:08:16 SQL Data In: ORACLE - Rows affected = 0 448 11:08:16 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 449 11:08:16 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 450 11:08:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 451 11:08:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 452 11:08:16 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 453 11:08:16 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 45 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 454 11:08:16 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 455 11:08:16 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 456 11:08:16 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 457 11:08:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 458 11:08:16 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 459 11:08:16 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 460 11:08:16 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874092,476,'wlzx-2','2',nvl('321050',' '),'192.168.13.206#730:11014@appYP_YF.exe+药房管理系统',45) 461 11:08:16 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874092,476,'wlzx-2','2',nvl('321050',' '),'192.168.13.206#730:11014@appYP_YF.exe+药房管理系统',45) 462 11:08:16 SQL Data In: ORACLE - Rows affected = 1 463 11:08:16 SQL Prepare: ORACLE - Commit 464 11:08:16 SQL Execute: ORACLE - Commit 465 11:08:16 SQL Data In: ORACLE - Rows affected = 0 466 11:08:16 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 467 11:08:16 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 468 11:08:16 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 469 11:08:16 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 470 11:08:16 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090904' 471 11:08:16 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='2') and YXQ000>='20090904' 472 11:08:16 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 473 11:08:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 474 11:08:16 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 475 11:08:16 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 476 11:08:16 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874092 477 11:08:16 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874092 478 11:08:16 SQL Data In: ORACLE - Rows affected = 1 479 11:08:16 SQL Prepare: ORACLE - Commit 480 11:08:16 SQL Execute: ORACLE - Commit 481 11:08:16 SQL Data In: ORACLE - Rows affected = 0 482 11:08:16 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 483 11:08:16 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 484 11:08:16 SQL Data In: ORACLE - Rows affected = 0 485 11:08:16 SQL Prepare: ORACLE - Commit 486 11:08:16 SQL Execute: ORACLE - Commit 487 11:08:16 SQL Data In: ORACLE - Rows affected = 0 488 11:08:16 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 489 11:08:16 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 490 11:08:16 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 491 11:08:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 492 11:08:16 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 493 11:08:16 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 494 11:08:16 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874093,476,'wlzx-2','2',nvl('321050',' '),'192.168.13.206#730:11014@appYP_YF.exe+药房管理系统',45) 495 11:08:16 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874093,476,'wlzx-2','2',nvl('321050',' '),'192.168.13.206#730:11014@appYP_YF.exe+药房管理系统',45) 496 11:08:16 SQL Data In: ORACLE - Rows affected = 1 497 11:08:16 SQL Prepare: ORACLE - Commit 498 11:08:16 SQL Execute: ORACLE - Commit 499 11:08:16 SQL Data In: ORACLE - Rows affected = 0 500 11:08:16 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 501 11:08:16 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 45 502 11:08:16 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 503 11:08:16 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 504 11:08:16 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 505 11:08:16 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 506 11:08:16 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 507 11:08:16 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 508 11:08:16 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 509 11:08:16 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 510 11:08:16 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 511 11:08:16 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=45 512 11:08:16 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 513 11:08:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 514 11:08:16 SQL Prepare: ORACLE - select * from XT_XTCS00 515 11:08:16 SQL Execute: ORACLE - select * from XT_XTCS00 516 11:08:18 SQL Prepare: ORACLE - select * from BM_YPLB00 517 11:08:18 SQL Execute: ORACLE - select * from BM_YPLB00 518 11:08:18 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=476 519 11:08:18 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=476 520 11:08:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 521 11:08:18 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 522 11:08:18 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 523 11:08:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 524 11:08:18 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 525 11:08:18 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 526 11:08:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 527 11:08:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 528 11:08:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 529 11:08:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 530 11:08:18 SQL Prepare: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 531 11:08:18 SQL Execute: ORACLE - SELECT SFXMMC FROM BM_YPLB00 where LBBH00='3' 532 11:08:21 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 533 11:08:21 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 534 11:08:21 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 535 11:08:21 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 536 11:08:21 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 537 11:08:21 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 538 11:08:21 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 539 11:08:21 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 540 11:08:21 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 541 11:08:21 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 542 11:08:21 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 543 11:08:21 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 544 11:08:21 SQL Prepare: ORACLE - select * from BM_YPLB00 545 11:08:21 SQL Execute: ORACLE - select * from BM_YPLB00 546 11:08:21 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 547 11:08:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 548 11:08:21 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 549 11:08:21 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 550 11:08:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 551 11:08:21 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 552 11:08:21 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 553 11:08:21 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 554 11:08:21 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 555 11:08:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 556 11:08:21 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 557 11:08:21 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 558 11:08:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 559 11:08:21 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 560 11:09:46 SQL Prepare: ORACLE - select B.MBLX00,C.MBMC00,B.BBID00,B.BBNAME from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) order by C.MBBH00,B.BBBH00 561 11:09:46 SQL Execute: ORACLE - select B.MBLX00,C.MBMC00,B.BBID00,B.BBNAME from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) order by C.MBBH00,B.BBBH00 562 11:09:51 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 563 11:09:51 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 564 11:09:51 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 565 11:09:51 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 566 11:09:51 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 567 11:09:51 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 568 11:09:51 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 569 11:09:51 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 570 11:09:51 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 571 11:09:51 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 572 11:09:51 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 573 11:09:51 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 574 11:09:51 SQL Prepare: ORACLE - select * from BM_YPLB00 575 11:09:51 SQL Execute: ORACLE - select * from BM_YPLB00 576 11:09:51 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 577 11:09:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 578 11:09:51 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 579 11:09:51 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 580 11:09:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 581 11:09:51 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 582 11:09:51 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 583 11:09:51 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 584 11:09:54 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 585 11:09:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 586 11:09:54 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 587 11:09:54 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 588 11:09:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 589 11:09:54 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 590 11:11:10 SQL Prepare: ORACLE - SELECT * FROM BM_YPLB00 591 11:11:10 SQL Execute: ORACLE - SELECT * FROM BM_YPLB00 592 11:11:10 SQL Prepare: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 593 11:11:10 SQL Execute: ORACLE - SELECT * FROM BM_YPYL00 WHERE LBBH00='0' 594 11:11:10 SQL Prepare: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 595 11:11:10 SQL Execute: ORACLE - SELECT * FROM BM_YPJX00 WHERE LBBH00='0' 596 11:11:10 SQL Prepare: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 597 11:11:10 SQL Execute: ORACLE - select ypdwmc from bm_ypdw00 order by to_number(ypdwbh) 598 11:11:10 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 599 11:11:10 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E2' and ( (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 600 11:11:10 SQL Prepare: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 601 11:11:10 SQL Execute: ORACLE - SELECT * FROM YF_TJLXB0 WHERE YFBMBH=45 602 11:11:10 SQL Prepare: ORACLE - select * from BM_YPLB00 603 11:11:10 SQL Execute: ORACLE - select * from BM_YPLB00 604 11:11:10 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 605 11:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 606 11:11:10 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 607 11:11:10 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 608 11:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 609 11:11:10 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 610 11:11:10 SQL Prepare: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 611 11:11:10 SQL Execute: ORACLE - select (SELECT SCCJZW FROM BM_YPSCCJ B WHERE A.SCCJBH=B.SCCJBH) as SCCJ00, A.* FROM VW_YF_YPKCXX A where LBBH00 like '0%' and YLBH00 like '%' and JXBH00 like '%' and YFBMBH=45 and TZRQ00 IS NULL order by YPBM00 612 11:11:10 SQL Prepare: ORACLE - select * from BM_YPJX00 where lbbh00=:1 613 11:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 614 11:11:10 SQL Execute: ORACLE - select * from BM_YPJX00 where lbbh00=? 615 11:11:10 SQL Prepare: ORACLE - select * from BM_YPYL00 where lbbh00=:1 616 11:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 617 11:11:10 SQL Execute: ORACLE - select * from BM_YPYL00 where lbbh00=? 618 11:14:19 Log started for: 后台维护系统 619 11:14:19 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.13.206','6',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 620 11:14:19 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '192.168.13.206','6',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 621 11:14:19 SQL Data In: ORACLE - Rows affected = 1 622 11:14:19 SQL Prepare: ORACLE - Commit 623 11:14:19 SQL Execute: ORACLE - Commit 624 11:14:19 SQL Data In: ORACLE - Rows affected = 0 625 11:14:19 SQL Prepare: ORACLE - Select SYSDATE from Dual 626 11:14:19 SQL Execute: ORACLE - Select SYSDATE from Dual 627 11:14:19 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 628 11:14:19 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 629 11:14:19 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 630 11:14:19 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 631 11:14:19 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 632 11:14:19 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 633 11:14:19 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 634 11:14:19 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 635 11:14:19 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 636 11:14:19 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 637 11:14:19 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='6' 638 11:14:19 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='6' 639 11:14:26 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') order by BH0000 640 11:14:26 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') order by BH0000 641 11:14:32 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where 'super'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER')) 642 11:14:32 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'super'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='SUPER')) 643 11:14:32 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00='1' 644 11:14:32 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='SUPER' and CZBZ00='1' 645 11:14:32 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 646 11:14:32 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 647 11:14:32 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 648 11:14:32 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 649 11:14:32 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 650 11:14:32 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 651 11:14:32 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 652 11:14:32 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 653 11:14:32 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 654 11:14:32 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 655 11:14:32 SQL Data In: ORACLE - Rows affected = 0 656 11:14:32 SQL Prepare: ORACLE - Commit 657 11:14:32 SQL Execute: ORACLE - Commit 658 11:14:32 SQL Data In: ORACLE - Rows affected = 0 659 11:14:32 SQL Prepare: ORACLE - select CKBH00,CKMC00 from BM_CKBM00 where BMBH00= 15 and FLAG00='' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 660 11:14:32 SQL Execute: ORACLE - select CKBH00,CKMC00 from BM_CKBM00 where BMBH00= 15 and FLAG00='' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 661 11:14:32 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 662 11:14:32 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 663 11:14:32 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 664 11:14:32 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 665 11:14:32 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874119,0,'wlzx-2','6',nvl('321095',' '),'',15) 666 11:14:32 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874119,0,'wlzx-2','6',nvl('321095',' '),'',15) 667 11:14:32 SQL Data In: ORACLE - Rows affected = 1 668 11:14:32 SQL Prepare: ORACLE - Commit 669 11:14:32 SQL Execute: ORACLE - Commit 670 11:14:32 SQL Data In: ORACLE - Rows affected = 0 671 11:14:32 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 672 11:14:32 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 673 11:14:32 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='6') and YXQ000>='20090904' 674 11:14:32 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='6') and YXQ000>='20090904' 675 11:14:32 SQL Prepare: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 676 11:14:32 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 677 11:14:32 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 678 11:14:32 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 679 11:14:32 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 680 11:14:32 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 681 11:14:32 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 682 11:14:32 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 683 11:14:32 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 a where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 684 11:14:32 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 a where XTDM00='6' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 685 11:14:32 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 686 11:14:32 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 687 11:14:32 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 688 11:14:32 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 689 11:14:32 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 690 11:14:32 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 0= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=0)))) 691 11:14:34 SQL Prepare: ORACLE - select distinct ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=4 order by ZBMC00 692 11:14:34 SQL Execute: ORACLE - select distinct ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=4 order by ZBMC00 693 11:14:34 SQL Prepare: ORACLE - Select BMBH00,BMMC00||'_'||BH0000 BMMC00 from BM_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' ORDER BY BMMC00 694 11:14:34 SQL Execute: ORACLE - Select BMBH00,BMMC00||'_'||BH0000 BMMC00 from BM_BMBM00 where FLAG00 ='1' and CZBZ00<>'2' ORDER BY BMMC00 695 11:14:34 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病历查询组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病历查询组' and t2.BMBH00=47) 696 11:14:34 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病历查询组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病历查询组' and t2.BMBH00=47) 697 11:14:34 SQL Prepare: ORACLE - Select ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=4 order by ZBMC00 698 11:14:34 SQL Execute: ORACLE - Select ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=4 order by ZBMC00 699 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='79' and ZBJB00 like '00%' 700 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='79' and ZBJB00 like '00%' 701 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='06' and ZBJB00 like '00%' 702 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='06' and ZBJB00 like '00%' 703 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='05' and ZBJB00 like '00%' 704 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='05' and ZBJB00 like '00%' 705 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='50' and ZBJB00 like '00%' 706 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='50' and ZBJB00 like '00%' 707 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='10' and ZBJB00 like '00%' 708 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='10' and ZBJB00 like '00%' 709 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='15' and ZBJB00 like '00%' 710 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='15' and ZBJB00 like '00%' 711 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='91' and ZBJB00 like '00%' 712 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='91' and ZBJB00 like '00%' 713 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='93' and ZBJB00 like '00%' 714 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='93' and ZBJB00 like '00%' 715 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='92' and ZBJB00 like '00%' 716 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='92' and ZBJB00 like '00%' 717 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='90' and ZBJB00 like '00%' 718 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='90' and ZBJB00 like '00%' 719 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='69' and ZBJB00 like '00%' 720 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='69' and ZBJB00 like '00%' 721 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='76' and ZBJB00 like '00%' 722 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='76' and ZBJB00 like '00%' 723 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='77' and ZBJB00 like '00%' 724 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='77' and ZBJB00 like '00%' 725 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='55' and ZBJB00 like '00%' 726 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='55' and ZBJB00 like '00%' 727 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='54' and ZBJB00 like '00%' 728 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='54' and ZBJB00 like '00%' 729 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='53' and ZBJB00 like '00%' 730 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='53' and ZBJB00 like '00%' 731 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='60' and ZBJB00 like '00%' 732 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='60' and ZBJB00 like '00%' 733 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='00' and ZBJB00 like '00%' 734 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='00' and ZBJB00 like '00%' 735 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='52' and ZBJB00 like '00%' 736 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='52' and ZBJB00 like '00%' 737 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='57' and ZBJB00 like '00%' 738 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='57' and ZBJB00 like '00%' 739 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='27' and ZBJB00 like '00%' 740 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='27' and ZBJB00 like '00%' 741 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='30' and ZBJB00 like '00%' 742 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='30' and ZBJB00 like '00%' 743 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='65' and ZBJB00 like '00%' 744 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='65' and ZBJB00 like '00%' 745 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='68' and ZBJB00 like '00%' 746 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='68' and ZBJB00 like '00%' 747 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='81' and ZBJB00 like '00%' 748 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='81' and ZBJB00 like '00%' 749 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='82' and ZBJB00 like '00%' 750 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='82' and ZBJB00 like '00%' 751 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='88' and ZBJB00 like '00%' 752 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='88' and ZBJB00 like '00%' 753 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='80' and ZBJB00 like '00%' 754 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='80' and ZBJB00 like '00%' 755 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='67' and ZBJB00 like '00%' 756 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='67' and ZBJB00 like '00%' 757 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='14' and ZBJB00 like '00%' 758 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='14' and ZBJB00 like '00%' 759 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='11' and ZBJB00 like '00%' 760 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='11' and ZBJB00 like '00%' 761 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='48' and ZBJB00 like '00%' 762 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='48' and ZBJB00 like '00%' 763 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='73' and ZBJB00 like '00%' 764 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='73' and ZBJB00 like '00%' 765 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='12' and ZBJB00 like '00%' 766 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='12' and ZBJB00 like '00%' 767 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='08' and ZBJB00 like '00%' 768 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='08' and ZBJB00 like '00%' 769 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='20' and ZBJB00 like '00%' 770 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='20' and ZBJB00 like '00%' 771 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='07' and ZBJB00 like '00%' 772 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='07' and ZBJB00 like '00%' 773 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='59' and ZBJB00 like '00%' 774 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='59' and ZBJB00 like '00%' 775 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='84' and ZBJB00 like '00%' 776 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='84' and ZBJB00 like '00%' 777 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='94' and ZBJB00 like '00%' 778 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='94' and ZBJB00 like '00%' 779 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='89' and ZBJB00 like '00%' 780 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='89' and ZBJB00 like '00%' 781 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='70' and ZBJB00 like '00%' 782 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='70' and ZBJB00 like '00%' 783 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='85' and ZBJB00 like '00%' 784 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='85' and ZBJB00 like '00%' 785 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='86' and ZBJB00 like '00%' 786 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='86' and ZBJB00 like '00%' 787 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='72' and ZBJB00 like '00%' 788 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='72' and ZBJB00 like '00%' 789 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='28' and ZBJB00 like '00%' 790 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='28' and ZBJB00 like '00%' 791 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='03' and ZBJB00 like '00%' 792 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='03' and ZBJB00 like '00%' 793 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='49' and ZBJB00 like '00%' 794 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='49' and ZBJB00 like '00%' 795 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='58' and ZBJB00 like '00%' 796 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='58' and ZBJB00 like '00%' 797 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='74' and ZBJB00 like '00%' 798 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='74' and ZBJB00 like '00%' 799 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='75' and ZBJB00 like '00%' 800 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='75' and ZBJB00 like '00%' 801 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='04' and ZBJB00 like '00%' 802 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='04' and ZBJB00 like '00%' 803 11:14:34 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='96' and ZBJB00 like '00%' 804 11:14:34 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='96' and ZBJB00 like '00%' 805 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='19' and ZBJB00 like '00%' 806 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='19' and ZBJB00 like '00%' 807 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='42' and ZBJB00 like '00%' 808 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='42' and ZBJB00 like '00%' 809 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='46' and ZBJB00 like '00%' 810 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='46' and ZBJB00 like '00%' 811 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='78' and ZBJB00 like '00%' 812 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='78' and ZBJB00 like '00%' 813 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='17' and ZBJB00 like '00%' 814 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='17' and ZBJB00 like '00%' 815 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='01' and ZBJB00 like '00%' 816 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='01' and ZBJB00 like '00%' 817 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='02' and ZBJB00 like '00%' 818 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='02' and ZBJB00 like '00%' 819 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='22' and ZBJB00 like '00%' 820 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='22' and ZBJB00 like '00%' 821 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='09' and ZBJB00 like '00%' 822 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='09' and ZBJB00 like '00%' 823 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='61' and ZBJB00 like '00%' 824 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='61' and ZBJB00 like '00%' 825 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='13' and ZBJB00 like '00%' 826 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='13' and ZBJB00 like '00%' 827 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='95' and ZBJB00 like '00%' 828 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='95' and ZBJB00 like '00%' 829 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='29' and ZBJB00 like '00%' 830 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='29' and ZBJB00 like '00%' 831 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='16' and ZBJB00 like '00%' 832 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='16' and ZBJB00 like '00%' 833 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='56' and ZBJB00 like '00%' 834 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='56' and ZBJB00 like '00%' 835 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='21' and ZBJB00 like '00%' 836 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='21' and ZBJB00 like '00%' 837 11:14:35 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='99' and ZBJB00 like '00%' 838 11:14:35 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='99' and ZBJB00 like '00%' 839 11:14:35 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 840 11:14:35 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 841 11:14:42 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病历查询组' ORDER BY XKH000 842 11:14:42 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病历查询组' ORDER BY XKH000 843 11:14:42 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病历查询组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病历查询组' and t2.BMBH00=47) 844 11:14:42 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病历查询组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病历查询组' and t2.BMBH00=47) 845 11:14:42 SQL Prepare: ORACLE - select * from XT_YYXT00 a where XTDM00 not in (select XTDM00 from VW_XT_YHZBXT where ZBMC00='病历查询组') 846 11:14:42 SQL Execute: ORACLE - select * from XT_YYXT00 a where XTDM00 not in (select XTDM00 from VW_XT_YHZBXT where ZBMC00='病历查询组') 847 11:14:42 SQL Prepare: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='病历查询组' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') and a.MKDM00 = d.MKDM00 ) 848 11:14:42 SQL Execute: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='病历查询组' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') and a.MKDM00 = d.MKDM00 ) 849 11:14:42 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房申领组' ORDER BY XKH000 850 11:14:42 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房申领组' ORDER BY XKH000 851 11:14:42 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47) 852 11:14:42 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47) 853 11:14:42 SQL Prepare: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') and a.MKDM00 = d.MKDM00 ) 854 11:14:42 SQL Execute: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') and a.MKDM00 = d.MKDM00 ) 855 11:14:43 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房申领组' ORDER BY XKH000 856 11:14:43 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房申领组' ORDER BY XKH000 857 11:14:45 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房申领组' ORDER BY XKH000 858 11:14:45 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房申领组' ORDER BY XKH000 859 11:14:45 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47) 860 11:14:45 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房申领组' and t2.BMBH00=47) 861 11:14:45 SQL Prepare: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') and a.MKDM00 = d.MKDM00 ) 862 11:14:45 SQL Execute: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房申领组') and a.MKDM00 = d.MKDM00 ) 863 11:14:46 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房组' ORDER BY XKH000 864 11:14:46 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房组' ORDER BY XKH000 865 11:14:46 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房组' and t2.BMBH00=47) 866 11:14:46 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房组' and t2.BMBH00=47) 867 11:14:46 SQL Prepare: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') and a.MKDM00 = d.MKDM00 ) 868 11:14:46 SQL Execute: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') and a.MKDM00 = d.MKDM00 ) 869 11:15:01 SQL Prepare: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 870 11:15:01 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 871 11:15:01 SQL Prepare: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 872 11:15:01 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 873 11:15:03 SQL Prepare: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 874 11:15:03 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 875 11:15:03 SQL Prepare: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 876 11:15:03 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 877 11:15:03 SQL Prepare: ORACLE - Select Distinct ZBJB00 from XT_XTZB00 where ZBDM00='10' 878 11:15:03 SQL Execute: ORACLE - Select Distinct ZBJB00 from XT_XTZB00 where ZBDM00='10' 879 11:15:03 SQL Prepare: ORACLE - Delete from XT_ZBQX00 where XTDM00='2' and ZBDM00='10' 880 11:15:03 SQL Execute: ORACLE - Delete from XT_ZBQX00 where XTDM00='2' and ZBDM00='10' 881 11:15:03 SQL Data In: ORACLE - Rows affected = 26 882 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','209','2') 883 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','209','2') 884 11:15:03 SQL Data In: ORACLE - Rows affected = 1 885 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','249','2') 886 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','249','2') 887 11:15:03 SQL Data In: ORACLE - Rows affected = 1 888 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','201','2') 889 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','201','2') 890 11:15:03 SQL Data In: ORACLE - Rows affected = 1 891 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','263','2') 892 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','263','2') 893 11:15:03 SQL Data In: ORACLE - Rows affected = 1 894 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','274','2') 895 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','274','2') 896 11:15:03 SQL Data In: ORACLE - Rows affected = 1 897 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','203','2') 898 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','203','2') 899 11:15:03 SQL Data In: ORACLE - Rows affected = 1 900 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','276','2') 901 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','276','2') 902 11:15:03 SQL Data In: ORACLE - Rows affected = 1 903 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','223','2') 904 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','223','2') 905 11:15:03 SQL Data In: ORACLE - Rows affected = 1 906 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','222','2') 907 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','222','2') 908 11:15:03 SQL Data In: ORACLE - Rows affected = 1 909 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','273','2') 910 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','273','2') 911 11:15:03 SQL Data In: ORACLE - Rows affected = 1 912 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','205','2') 913 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','205','2') 914 11:15:03 SQL Data In: ORACLE - Rows affected = 1 915 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','206','2') 916 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','206','2') 917 11:15:03 SQL Data In: ORACLE - Rows affected = 1 918 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','211','2') 919 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','211','2') 920 11:15:03 SQL Data In: ORACLE - Rows affected = 1 921 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','255','2') 922 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','255','2') 923 11:15:03 SQL Data In: ORACLE - Rows affected = 1 924 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','245','2') 925 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','245','2') 926 11:15:03 SQL Data In: ORACLE - Rows affected = 1 927 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','225','2') 928 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','225','2') 929 11:15:03 SQL Data In: ORACLE - Rows affected = 1 930 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','202','2') 931 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','202','2') 932 11:15:03 SQL Data In: ORACLE - Rows affected = 1 933 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','251','2') 934 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','251','2') 935 11:15:03 SQL Data In: ORACLE - Rows affected = 1 936 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','250','2') 937 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','250','2') 938 11:15:03 SQL Data In: ORACLE - Rows affected = 1 939 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','207','2') 940 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','207','2') 941 11:15:03 SQL Data In: ORACLE - Rows affected = 1 942 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','210','2') 943 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','210','2') 944 11:15:03 SQL Data In: ORACLE - Rows affected = 1 945 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','236','2') 946 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','236','2') 947 11:15:03 SQL Data In: ORACLE - Rows affected = 1 948 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','258','2') 949 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','258','2') 950 11:15:03 SQL Data In: ORACLE - Rows affected = 1 951 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','242','2') 952 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','242','2') 953 11:15:03 SQL Data In: ORACLE - Rows affected = 1 954 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','261','2') 955 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','261','2') 956 11:15:03 SQL Data In: ORACLE - Rows affected = 1 957 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','246','2') 958 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','246','2') 959 11:15:03 SQL Data In: ORACLE - Rows affected = 1 960 11:15:03 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','212','2') 961 11:15:03 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','212','2') 962 11:15:03 SQL Data In: ORACLE - Rows affected = 1 963 11:15:03 SQL Prepare: ORACLE - Delete from XT_ZBQX00 where ZBDM00 in ( select ZBDM00 from XT_XTZB00 where ZBJB00>'0010' and ZBJB00<='001099') and MKDM00 not in ( select distinct MKDM00 from XT_YHZB00 where ZBDM00='10' ) 964 11:15:03 SQL Execute: ORACLE - Delete from XT_ZBQX00 where ZBDM00 in ( select ZBDM00 from XT_XTZB00 where ZBJB00>'0010' and ZBJB00<='001099') and MKDM00 not in ( select distinct MKDM00 from XT_YHZB00 where ZBDM00='10' ) 965 11:15:03 SQL Data In: ORACLE - Rows affected = 0 966 11:15:03 SQL Prepare: ORACLE - Commit 967 11:15:03 SQL Execute: ORACLE - Commit 968 11:15:03 SQL Data In: ORACLE - Rows affected = 0 969 11:15:03 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房组' ORDER BY XKH000 970 11:15:03 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房组' ORDER BY XKH000 971 11:15:03 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房组' and t2.BMBH00=47) 972 11:15:03 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病区药房组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病区药房组' and t2.BMBH00=47) 973 11:15:03 SQL Prepare: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') and a.MKDM00 = d.MKDM00 ) 974 11:15:03 SQL Execute: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='药房管理系统' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='药房管理系统' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='病区药房组') and a.MKDM00 = d.MKDM00 ) 975 11:15:03 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房组' ORDER BY XKH000 976 11:15:03 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病区药房组' ORDER BY XKH000 977 11:18:16 SQL Prepare: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 978 11:18:16 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 979 11:18:16 SQL Prepare: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 980 11:18:16 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 981 11:18:20 SQL Prepare: ORACLE - Select ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=4 order by ZBMC00 982 11:18:20 SQL Execute: ORACLE - Select ZBDM00,ZBMC00 from XT_XTZB00 where ZBJB00 like '00%' and Length(Trim(ZBJB00))>=2 and Length(Trim(ZBJB00))<=4 order by ZBMC00 983 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='79' and ZBJB00 like '00%' 984 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='79' and ZBJB00 like '00%' 985 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='06' and ZBJB00 like '00%' 986 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='06' and ZBJB00 like '00%' 987 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='05' and ZBJB00 like '00%' 988 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='05' and ZBJB00 like '00%' 989 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='50' and ZBJB00 like '00%' 990 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='50' and ZBJB00 like '00%' 991 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='10' and ZBJB00 like '00%' 992 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='10' and ZBJB00 like '00%' 993 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='15' and ZBJB00 like '00%' 994 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='15' and ZBJB00 like '00%' 995 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='91' and ZBJB00 like '00%' 996 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='91' and ZBJB00 like '00%' 997 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='93' and ZBJB00 like '00%' 998 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='93' and ZBJB00 like '00%' 999 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='92' and ZBJB00 like '00%' 1000 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='92' and ZBJB00 like '00%' 1001 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='90' and ZBJB00 like '00%' 1002 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='90' and ZBJB00 like '00%' 1003 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='69' and ZBJB00 like '00%' 1004 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='69' and ZBJB00 like '00%' 1005 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='76' and ZBJB00 like '00%' 1006 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='76' and ZBJB00 like '00%' 1007 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='77' and ZBJB00 like '00%' 1008 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='77' and ZBJB00 like '00%' 1009 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='55' and ZBJB00 like '00%' 1010 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='55' and ZBJB00 like '00%' 1011 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='54' and ZBJB00 like '00%' 1012 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='54' and ZBJB00 like '00%' 1013 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='53' and ZBJB00 like '00%' 1014 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='53' and ZBJB00 like '00%' 1015 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='60' and ZBJB00 like '00%' 1016 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='60' and ZBJB00 like '00%' 1017 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='00' and ZBJB00 like '00%' 1018 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='00' and ZBJB00 like '00%' 1019 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='52' and ZBJB00 like '00%' 1020 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='52' and ZBJB00 like '00%' 1021 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='57' and ZBJB00 like '00%' 1022 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='57' and ZBJB00 like '00%' 1023 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='27' and ZBJB00 like '00%' 1024 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='27' and ZBJB00 like '00%' 1025 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='30' and ZBJB00 like '00%' 1026 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='30' and ZBJB00 like '00%' 1027 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='65' and ZBJB00 like '00%' 1028 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='65' and ZBJB00 like '00%' 1029 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='68' and ZBJB00 like '00%' 1030 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='68' and ZBJB00 like '00%' 1031 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='81' and ZBJB00 like '00%' 1032 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='81' and ZBJB00 like '00%' 1033 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='82' and ZBJB00 like '00%' 1034 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='82' and ZBJB00 like '00%' 1035 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='88' and ZBJB00 like '00%' 1036 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='88' and ZBJB00 like '00%' 1037 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='80' and ZBJB00 like '00%' 1038 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='80' and ZBJB00 like '00%' 1039 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='67' and ZBJB00 like '00%' 1040 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='67' and ZBJB00 like '00%' 1041 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='14' and ZBJB00 like '00%' 1042 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='14' and ZBJB00 like '00%' 1043 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='11' and ZBJB00 like '00%' 1044 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='11' and ZBJB00 like '00%' 1045 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='48' and ZBJB00 like '00%' 1046 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='48' and ZBJB00 like '00%' 1047 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='73' and ZBJB00 like '00%' 1048 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='73' and ZBJB00 like '00%' 1049 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='12' and ZBJB00 like '00%' 1050 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='12' and ZBJB00 like '00%' 1051 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='08' and ZBJB00 like '00%' 1052 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='08' and ZBJB00 like '00%' 1053 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='20' and ZBJB00 like '00%' 1054 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='20' and ZBJB00 like '00%' 1055 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='07' and ZBJB00 like '00%' 1056 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='07' and ZBJB00 like '00%' 1057 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='59' and ZBJB00 like '00%' 1058 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='59' and ZBJB00 like '00%' 1059 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='84' and ZBJB00 like '00%' 1060 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='84' and ZBJB00 like '00%' 1061 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='94' and ZBJB00 like '00%' 1062 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='94' and ZBJB00 like '00%' 1063 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='89' and ZBJB00 like '00%' 1064 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='89' and ZBJB00 like '00%' 1065 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='70' and ZBJB00 like '00%' 1066 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='70' and ZBJB00 like '00%' 1067 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='85' and ZBJB00 like '00%' 1068 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='85' and ZBJB00 like '00%' 1069 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='86' and ZBJB00 like '00%' 1070 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='86' and ZBJB00 like '00%' 1071 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='72' and ZBJB00 like '00%' 1072 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='72' and ZBJB00 like '00%' 1073 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='28' and ZBJB00 like '00%' 1074 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='28' and ZBJB00 like '00%' 1075 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='03' and ZBJB00 like '00%' 1076 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='03' and ZBJB00 like '00%' 1077 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='49' and ZBJB00 like '00%' 1078 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='49' and ZBJB00 like '00%' 1079 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='58' and ZBJB00 like '00%' 1080 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='58' and ZBJB00 like '00%' 1081 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='74' and ZBJB00 like '00%' 1082 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='74' and ZBJB00 like '00%' 1083 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='75' and ZBJB00 like '00%' 1084 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='75' and ZBJB00 like '00%' 1085 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='04' and ZBJB00 like '00%' 1086 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='04' and ZBJB00 like '00%' 1087 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='96' and ZBJB00 like '00%' 1088 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='96' and ZBJB00 like '00%' 1089 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='19' and ZBJB00 like '00%' 1090 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='19' and ZBJB00 like '00%' 1091 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='42' and ZBJB00 like '00%' 1092 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='42' and ZBJB00 like '00%' 1093 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='46' and ZBJB00 like '00%' 1094 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='46' and ZBJB00 like '00%' 1095 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='78' and ZBJB00 like '00%' 1096 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='78' and ZBJB00 like '00%' 1097 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='17' and ZBJB00 like '00%' 1098 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='17' and ZBJB00 like '00%' 1099 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='01' and ZBJB00 like '00%' 1100 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='01' and ZBJB00 like '00%' 1101 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='02' and ZBJB00 like '00%' 1102 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='02' and ZBJB00 like '00%' 1103 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='22' and ZBJB00 like '00%' 1104 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='22' and ZBJB00 like '00%' 1105 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='09' and ZBJB00 like '00%' 1106 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='09' and ZBJB00 like '00%' 1107 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='61' and ZBJB00 like '00%' 1108 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='61' and ZBJB00 like '00%' 1109 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='13' and ZBJB00 like '00%' 1110 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='13' and ZBJB00 like '00%' 1111 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='95' and ZBJB00 like '00%' 1112 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='95' and ZBJB00 like '00%' 1113 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='29' and ZBJB00 like '00%' 1114 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='29' and ZBJB00 like '00%' 1115 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='16' and ZBJB00 like '00%' 1116 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='16' and ZBJB00 like '00%' 1117 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='56' and ZBJB00 like '00%' 1118 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='56' and ZBJB00 like '00%' 1119 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='21' and ZBJB00 like '00%' 1120 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='21' and ZBJB00 like '00%' 1121 11:18:20 SQL Prepare: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='99' and ZBJB00 like '00%' 1122 11:18:20 SQL Execute: ORACLE - Select * from VW_XT_YHZBXT a Where ZBDM00='99' and ZBJB00 like '00%' 1123 11:18:21 SQL Prepare: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 1124 11:18:21 SQL Execute: ORACLE - Select * from XT_XTZB00 where ZBMC00 = '病区药房组' 1125 11:18:21 SQL Prepare: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 1126 11:18:21 SQL Execute: ORACLE - Select * from XT_YYXT00 where XTMC00 = '药房管理系统' 1127 11:18:21 SQL Prepare: ORACLE - Select Distinct ZBJB00 from XT_XTZB00 where ZBDM00='10' 1128 11:18:21 SQL Execute: ORACLE - Select Distinct ZBJB00 from XT_XTZB00 where ZBDM00='10' 1129 11:18:21 SQL Prepare: ORACLE - Delete from XT_ZBQX00 where XTDM00='2' and ZBDM00='10' 1130 11:18:21 SQL Execute: ORACLE - Delete from XT_ZBQX00 where XTDM00='2' and ZBDM00='10' 1131 11:18:21 SQL Data In: ORACLE - Rows affected = 27 1132 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','209','2') 1133 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','209','2') 1134 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1135 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','249','2') 1136 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','249','2') 1137 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1138 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','201','2') 1139 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','201','2') 1140 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1141 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','263','2') 1142 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','263','2') 1143 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1144 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','274','2') 1145 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','274','2') 1146 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1147 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','203','2') 1148 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','203','2') 1149 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1150 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','276','2') 1151 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','276','2') 1152 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1153 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','2E2','2') 1154 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','2E2','2') 1155 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1156 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','223','2') 1157 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','223','2') 1158 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1159 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','222','2') 1160 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','222','2') 1161 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1162 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','273','2') 1163 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','273','2') 1164 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1165 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','205','2') 1166 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','205','2') 1167 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1168 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','206','2') 1169 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','206','2') 1170 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1171 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','211','2') 1172 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','211','2') 1173 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1174 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','255','2') 1175 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','255','2') 1176 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1177 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','245','2') 1178 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','245','2') 1179 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1180 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','225','2') 1181 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','225','2') 1182 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1183 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','202','2') 1184 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','202','2') 1185 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1186 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','251','2') 1187 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','251','2') 1188 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1189 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','250','2') 1190 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','250','2') 1191 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1192 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','207','2') 1193 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','207','2') 1194 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1195 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','210','2') 1196 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','210','2') 1197 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1198 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','236','2') 1199 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','236','2') 1200 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1201 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','258','2') 1202 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','258','2') 1203 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1204 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','242','2') 1205 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','242','2') 1206 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1207 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','261','2') 1208 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','261','2') 1209 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1210 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','246','2') 1211 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','246','2') 1212 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1213 11:18:21 SQL Prepare: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','212','2') 1214 11:18:21 SQL Execute: ORACLE - Insert into XT_ZBQX00(ZBDM00,MKDM00,XTDM00) values( '10','212','2') 1215 11:18:21 SQL Data In: ORACLE - Rows affected = 1 1216 11:18:21 SQL Prepare: ORACLE - Delete from XT_ZBQX00 where ZBDM00 in ( select ZBDM00 from XT_XTZB00 where ZBJB00>'0010' and ZBJB00<='001099') and MKDM00 not in ( select distinct MKDM00 from XT_YHZB00 where ZBDM00='10' ) 1217 11:18:21 SQL Execute: ORACLE - Delete from XT_ZBQX00 where ZBDM00 in ( select ZBDM00 from XT_XTZB00 where ZBJB00>'0010' and ZBJB00<='001099') and MKDM00 not in ( select distinct MKDM00 from XT_YHZB00 where ZBDM00='10' ) 1218 11:18:21 SQL Data In: ORACLE - Rows affected = 0 1219 11:18:21 SQL Prepare: ORACLE - Commit 1220 11:18:21 SQL Execute: ORACLE - Commit 1221 11:18:21 SQL Data In: ORACLE - Rows affected = 0 1222 11:18:21 SQL Prepare: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病历查询组' ORDER BY XKH000 1223 11:18:21 SQL Execute: ORACLE - Select a.*,c.ZWXM00,c.PYSM00,c.XKH000, DECODE(DECODE(INSTR(c.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(c.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from XT_YHZB00 a,XT_XTZB00 b,BM_YGBM00 c where a.ZBDM00=b.ZBDM00 and a.YGBH00=c.YGBH00 and a.YGBH00<>0 and c.CZBZ00<>'2' and b.ZBMC00='病历查询组' ORDER BY XKH000 1224 11:18:21 SQL Prepare: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病历查询组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病历查询组' and t2.BMBH00=47) 1225 11:18:21 SQL Execute: ORACLE - Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',1,'女',0,1) XB from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t1.YGBH00<>0 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t4.ZBMC00='病历查询组' and t2.BMBH00=47 Union Select t1.YGBH00,t1.ZWXM00,t1.PYSM00,t1.XKH000, DECODE(DECODE(INSTR(t1.XB0000,'男',1,1),1,'男')|| DECODE(INSTR(t1.XB0000,'女',1,1),1,'女'),'男',3,'女',2,3) XB from BM_YGBM00 t1,BM_BMBM00 t2 where t1.BMBH00=t2.BMBH00 and t2.FLAG00='1' and t1.CZBZ00<>'2' and t2.BMBH00=47 and t1.YGBH00<>0 and t1.YGBH00 not in ( select distinct t1.YGBH00 from BM_YGBM00 t1,BM_BMBM00 t2,XT_YHZB00 t3,XT_XTZB00 t4 where t1.BMBH00=t2.BMBH00 and t1.YGBH00=t3.YGBH00 and t3.ZBDM00=t4.ZBDM00 and t2.FLAG00='1' and t4.ZBMC00='病历查询组' and t2.BMBH00=47) 1226 11:18:21 SQL Prepare: ORACLE - select * from XT_YYXT00 a where XTDM00 not in (select XTDM00 from VW_XT_YHZBXT where ZBMC00='病历查询组') 1227 11:18:21 SQL Execute: ORACLE - select * from XT_YYXT00 a where XTDM00 not in (select XTDM00 from VW_XT_YHZBXT where ZBMC00='病历查询组') 1228 11:18:21 SQL Prepare: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='病历查询组' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') and a.MKDM00 = d.MKDM00 ) 1229 11:18:21 SQL Execute: ORACLE - select distinct MKWBMC,MKDM00,'1' Flag from VW_XT_YHHDMK a Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') union select distinct a.MKWBMC,a.MKDM00,'0' from XT_XTMK00 a,XT_YYXT00 b where a.XTDM00=b.XTDM00 and b.XTMC00='病历查询组' and NOT EXISTS ( select d.MKWBMC from VW_XT_YHHDMK d Where XTMC00='病历查询组' and ZBDM00=(select ZBDM00 from XT_XTZB00 WHERE ZBMC00='福建省长乐市医院') and a.MKDM00 = d.MKDM00 ) 1230 11:18:21 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 1231 11:18:21 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 1232 11:19:03 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874119 1233 11:19:03 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=1874119 1234 11:19:03 SQL Data In: ORACLE - Rows affected = 1 1235 11:19:03 SQL Prepare: ORACLE - Commit 1236 11:19:03 SQL Execute: ORACLE - Commit 1237 11:19:03 SQL Data In: ORACLE - Rows affected = 0 1238 11:19:03 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 1239 11:19:03 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 1240 11:19:03 SQL Data In: ORACLE - Rows affected = 0 1241 11:19:03 SQL Prepare: ORACLE - Commit 1242 11:19:03 SQL Execute: ORACLE - Commit 1243 11:19:03 SQL Data In: ORACLE - Rows affected = 0 1244 11:19:04 Log started for: 药房管理系统 1245 11:22:27 Log started for: Gysystem 1246 11:22:27 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20090904','11:22:26','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 1247 11:22:27 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20090904','11:22:26','scott@9998:AA187611476484C390088D38B2ABCDDA' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 1248 11:22:27 SQL Data In: ORACLE - Rows affected = 1 1249 11:22:27 SQL Prepare: ORACLE - Commit 1250 11:22:27 SQL Execute: ORACLE - Commit 1251 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1252 11:22:27 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 1253 11:22:27 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 1254 11:22:27 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 1255 11:22:27 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 1256 11:22:27 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20090904','11:22:26','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 1257 11:22:27 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.13.206','F',trim(PROGRAM)||'+'||'供应室管理子系统',SID,serial# ,'20090904','11:22:26','sd_Hospital@9998:F728A165FF1B658275D1BFE5E1A5AB9D' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 1258 11:22:27 SQL Data In: ORACLE - Rows affected = 1 1259 11:22:27 SQL Prepare: ORACLE - Commit 1260 11:22:27 SQL Execute: ORACLE - Commit 1261 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1262 11:22:27 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 1263 11:22:27 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 1264 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1265 11:22:27 SQL Prepare: ORACLE - Commit 1266 11:22:27 SQL Execute: ORACLE - Commit 1267 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1268 11:22:27 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 1269 11:22:27 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='F' 1270 11:22:27 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 1271 11:22:27 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 1272 11:22:27 SQL Prepare: ORACLE - Select SYSDATE from Dual 1273 11:22:27 SQL Execute: ORACLE - Select SYSDATE from Dual 1274 11:22:27 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 1275 11:22:27 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 1276 11:22:27 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 1277 11:22:27 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='F' 1278 11:22:27 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 1279 11:22:27 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 1280 11:22:27 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 1281 11:22:27 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 1282 11:22:27 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 1283 11:22:27 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') and KLDH00 = '' 1284 11:22:27 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 1285 11:22:27 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('a','0','1','2','3','4','5','6','8','9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='F' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 1286 11:22:27 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 1287 11:22:27 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'F' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 1288 11:22:27 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 1289 11:22:27 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 1290 11:22:27 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 1291 11:22:27 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 1292 11:22:27 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 1293 11:22:27 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 1294 11:22:27 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 1295 11:22:27 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 1296 11:22:27 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 1297 11:22:27 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 1298 11:22:27 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 1299 11:22:27 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 1300 11:22:27 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874143,476,'wlzx-2','F',nvl('321139',' '),'192.168.13.206#816:478@GYSystem.exe+供应室管理子系统',150) 1301 11:22:27 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1874143,476,'wlzx-2','F',nvl('321139',' '),'192.168.13.206#816:478@GYSystem.exe+供应室管理子系统',150) 1302 11:22:27 SQL Data In: ORACLE - Rows affected = 1 1303 11:22:27 SQL Prepare: ORACLE - Commit 1304 11:22:27 SQL Execute: ORACLE - Commit 1305 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1306 11:22:27 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150 1307 11:22:27 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 150 1308 11:22:27 SQL Prepare: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 1309 11:22:27 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 1310 11:22:27 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 1311 11:22:27 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.13.206' 1312 11:22:27 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 1313 11:22:27 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 1314 11:22:27 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 1315 11:22:27 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 1316 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1317 11:22:27 SQL Prepare: ORACLE - Commit 1318 11:22:27 SQL Execute: ORACLE - Commit 1319 11:22:27 SQL Data In: ORACLE - Rows affected = 0 1320 11:22:27 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 150 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 1321 11:22:27 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 150 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 1322 11:22:28 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 1323 11:22:28 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 1324 11:22:28 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20090904' 1325 11:22:28 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where XXXZ00 = '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',150,')> 0) and YXQ000>='20090904' 1326 11:22:28 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 1327 11:22:28 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 1328 11:22:28 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 1329 11:22:28 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 1330 11:22:28 SQL Prepare: ORACLE - select sysdate from dual 1331 11:22:28 SQL Execute: ORACLE - select sysdate from dual 1332 11:22:28 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 1333 11:22:28 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 1334 11:22:28 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 1335 11:22:28 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 1336 11:22:28 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 1337 11:22:28 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 1338 11:22:28 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 1339 11:22:28 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 1340 11:22:28 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 a where XTDM00='F' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1341 11:22:28 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 a where XTDM00='F' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1342 11:22:28 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 1343 11:22:28 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'F$%' and A.XTDM00='F' and trim(A.MKDM00)='F$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='F' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 1344 11:22:28 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1345 11:22:28 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1346 11:22:28 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1347 11:22:28 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 a where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1348 11:22:28 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1349 11:22:28 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 1350 11:22:28 SQL Prepare: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 1351 11:22:28 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 1352 11:22:28 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 1353 11:22:28 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 476 1354 11:22:28 SQL Prepare: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR') 1355 11:22:28 SQL Execute: ORACLE - Select value0,name00 from XT_XTCS00 where name00 in('GY_ZDYYCS','GY_HSQRDYSFAKSFL','GY_WPKCCXFS','GY_YJZWPLYSFZJFF','GY_WPCKTJFS','GY_WPCKTJHJXSSFWL','GY_WPRKSCCJSFYXZJLR') 1356 11:22:28 SQL Prepare: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 1357 11:22:28 SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 1358 11:22:28 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 1359 11:22:28 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 1360 11:22:28 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 1361 11:22:28 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 1362 11:22:28 SQL Prepare: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 1363 11:22:28 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 1364 11:22:28 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB' 1365 11:22:28 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=476 and name00='GY_QSBRLB' 1366 11:22:28 SQL Prepare: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=:1 and yxq000<:2 1367 11:22:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 150.000000 1368 11:22:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090904 1369 11:22:28 SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=? and yxq000