1 16:28:52 Log started for: 药房管理系统 2 16:28:52 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 3 16:28:52 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.233','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20120702','16:28:53','scott@8023:8EE817482433546AEAF678B6C219CC8F' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 16:28:52 SQL Data In: ORACLE - Rows affected = 1 5 16:28:52 SQL Execute: ORACLE - Commit 6 16:28:52 SQL Data In: ORACLE - Rows affected = 0 7 16:28:52 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 16:28:52 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222212' 9 16:28:52 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='8023' and CZBZ00 in ('1') 10 16:28:52 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.233','2',trim(PROGRAM)||'+'||'药房管理系统',SID,serial# ,'20120702','16:28:53','sd_hospital@8023:37DEE7BB9143F04A7BE0CFDD2F94BD08' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 11 16:28:52 SQL Data In: ORACLE - Rows affected = 1 12 16:28:52 SQL Execute: ORACLE - Commit 13 16:28:52 SQL Data In: ORACLE - Rows affected = 0 14 16:28:52 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 15 16:28:52 SQL Data In: ORACLE - Rows affected = 0 16 16:28:52 SQL Execute: ORACLE - Commit 17 16:28:52 SQL Data In: ORACLE - Rows affected = 0 18 16:28:52 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 19 16:28:52 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='8023' and CZBZ00 in ('1') 20 16:28:52 SQL Execute: ORACLE - Select SYSDATE from Dual 21 16:28:52 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 22 16:28:52 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 23 16:28:52 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 24 16:28:52 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 25 16:28:52 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 26 16:28:52 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('2','3') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023')) order by b.PLXH00,a.BH0000 27 16:28:52 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '8023'='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)='8023')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023') 28 16:28:52 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=108 29 16:28:52 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 30 16:28:52 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 31 16:28:52 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 32 16:28:52 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 33 16:28:52 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')) 34 16:28:52 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1681224,108,'zyy104','2',nvl('686234',' '),'192.168.6.180-192.168.1.233#154:1858@appYP_YF.exe+药房管理系统',26) 35 16:28:52 SQL Data In: ORACLE - Rows affected = 1 36 16:28:52 SQL Execute: ORACLE - Commit 37 16:28:52 SQL Data In: ORACLE - Rows affected = 0 38 16:28:52 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 26 39 16:28:52 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222212' 40 16:28:52 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 41 16:28:52 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.233' 42 16:28:52 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 43 16:28:52 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 26 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 44 16:28:52 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222212') 45 16:28:52 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 46 16:28:53 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '8023'='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)='8023')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023') 47 16:28:53 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=108 48 16:28:53 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 49 16:28:53 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 50 16:28:53 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 51 16:28:53 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 52 16:28:53 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')) 53 16:28:53 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1681225,108,'zyy104','2',nvl('686234',' '),'192.168.6.180-192.168.1.233#154:1858@appYP_YF.exe+药房管理系统',26) 54 16:28:53 SQL Data In: ORACLE - Rows affected = 1 55 16:28:53 SQL Execute: ORACLE - Commit 56 16:28:53 SQL Data In: ORACLE - Rows affected = 0 57 16:28:53 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 26 58 16:28:53 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222212' 59 16:28:53 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 60 16:28:54 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '8023'='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)='8023')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023') 61 16:28:54 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=108 62 16:28:54 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 63 16:28:54 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 64 16:28:54 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 65 16:28:54 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 66 16:28:54 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')) 67 16:28:54 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1681226,108,'zyy104','2',nvl('686234',' '),'192.168.6.180-192.168.1.233#154:1858@appYP_YF.exe+药房管理系统',26) 68 16:28:54 SQL Data In: ORACLE - Rows affected = 1 69 16:28:54 SQL Execute: ORACLE - Commit 70 16:28:54 SQL Data In: ORACLE - Rows affected = 0 71 16:28:54 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 26 72 16:28:54 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222212' 73 16:28:54 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 74 16:28:54 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '8023'='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)='8023')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023') 75 16:28:54 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=108 76 16:28:54 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 77 16:28:54 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 78 16:28:54 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 79 16:28:54 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 80 16:28:54 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')) 81 16:28:54 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1681227,108,'zyy104','2',nvl('686234',' '),'192.168.6.180-192.168.1.233#154:1858@appYP_YF.exe+药房管理系统',26) 82 16:28:54 SQL Data In: ORACLE - Rows affected = 1 83 16:28:54 SQL Execute: ORACLE - Commit 84 16:28:54 SQL Data In: ORACLE - Rows affected = 0 85 16:28:54 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 26 86 16:28:54 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222212' 87 16:28:54 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 88 16:28:55 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '8023'='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)='8023')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='8023') 89 16:28:55 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=108 90 16:28:55 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 91 16:28:55 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 92 16:28:55 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 93 16:28:55 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 94 16:28:55 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')) 95 16:28:55 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1681228,108,'zyy104','2',nvl('686234',' '),'192.168.6.180-192.168.1.233#154:1858@appYP_YF.exe+药房管理系统',26) 96 16:28:55 SQL Data In: ORACLE - Rows affected = 1 97 16:28:55 SQL Execute: ORACLE - Commit 98 16:28:55 SQL Data In: ORACLE - Rows affected = 0 99 16:28:55 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 26 100 16:28:55 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222212' 101 16:28:55 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL