1 09:37:40 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'jjyy'='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)='JJYY')) 2 09:37:40 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1150 3 09:37:40 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 4 09:37:40 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 5 09:37:40 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 6 09:37:40 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 7 09:37:40 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')) 8 09:37:40 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2838572,1150,'隔离病房02','F',nvl('1618611',' '),'192.168.1.228#11:3152@GYSystem.exe+供应室管理子系统',77) 9 09:37:40 SQL Data In: ORACLE - Rows affected = 1 10 09:37:40 SQL Execute: ORACLE - Commit 11 09:37:40 SQL Data In: ORACLE - Rows affected = 0 12 09:37:40 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 77 13 09:37:40 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 14 09:37:40 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '221094' 15 09:37:40 SQL Execute: ORACLE - Select NAME00,value0 from XT_XTCS00 where NAME00='YF_CKJRZTXG' 16 09:37:40 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.228' 17 09:37:40 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_SQIPDZ' and trim(VALUE0)='Y' 18 09:37:40 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='1' where JQBH00=0 19 09:37:40 SQL Data In: ORACLE - Rows affected = 0 20 09:37:40 SQL Execute: ORACLE - Commit 21 09:37:40 SQL Data In: ORACLE - Rows affected = 0 22 09:37:40 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 77 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 23 09:37:40 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('221094') 24 09:37:40 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'F'||',')>0 25 09:37:41 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 26 09:37:41 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 ||',', ',77,')> 0) and YXQ000>='20120730' 27 09:37:41 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_XTXXTLSJ','XT_XTXXXSZDR','XT_XTXXXSZT') 28 09:37:41 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 29 09:37:41 SQL Execute: ORACLE - select * from VW_XT_XTXXTS where 1=1 and XXXZ00= '1' and (XTDM00='-1' or XTDM00='F') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',77,')> 0) and YXQ000>='20120730' order by XH0000 30 09:38:44 SQL Execute: ORACLE - select * from VW_XT_XTXXTS where 1=1 and XXXZ00= '0' and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',77,')> 0) and YXQ000>='20120730' order by XH0000 31 09:38:46 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 32 09:38:46 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 33 09:38:46 SQL Execute: ORACLE - select sysdate from dual 34 09:38:46 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS<>'VALID' 35 09:38:46 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_GY_%' AND STATUS='VALID' 36 09:38:46 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_GY_%' AND STATUS<>'ENABLED' 37 09:38:46 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='XT_SFSZGLYQX' 38 09:38:46 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='F' and (( 1150= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1150 and XTDM00='F'))) 39 09:38:46 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 BZ0000<>'0' ORDER BY B.F_TEMPTYPE,A.MKDM00 40 09:38:46 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 ((1150= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1150 and XTDM00='0 '))) 41 09:38:46 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1150= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1150 and XTDM00='+ '))) 42 09:38:46 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 1150= 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=1150)))) 43 09:38:46 SQL Execute: ORACLE - select Value0 from xt_xtcs00 where name00='YZSJFG' and rownum=1 44 09:38:46 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 1150 45 09:38:46 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','GY_WPHSSFHZ','WZ_SYDJJEBLSWXS','GY_WPLYSFYXBTLXTYD','GY_WPHSQRTHYYHSSFXSSZ', 'GY_WPLYQRHZDY','GY_WPHSQRXSPCXX','GY_WPLYQRSFFKXX','GY_WPDBXDYXQTS','GY_WPCKTJXSSZ','GY_LYWPHSCXSFXSWPTJ' ) 46 09:38:46 SQL Execute: ORACLE - Select Name00,value0 from XT_XTCS00 where name00='GY_WLYYDY' 47 09:38:46 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPXSFY' 48 09:38:46 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYLB' 49 09:38:46 SQL Execute: ORACLE - Select value0 from XT_XTCS00 where name00='GY_WPLYZDYID' 50 09:38:47 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00=1150 and name00='GY_QSBRLB' 51 09:38:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 77.000000 52 09:38:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120730 53 09:38:47 SQL Execute: ORACLE - SELECT 1 FLAG00 FROM vw_gy_wpgqgl A Where gyksbh=? and yxq000