1 10:09:11 Log started for: Sickberth 2 10:09:11 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','830','38556' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 3 10:09:11 SQL Data In: ORACLE - Rows affected = 1 4 10:09:11 SQL Execute: ORACLE - Commit 5 10:09:11 SQL Data In: ORACLE - Rows affected = 0 6 10:09:11 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 7 10:09:12 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 8 10:09:12 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 9 10:09:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 10 10:09:12 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','792','5386' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual 11 10:09:12 SQL Data In: ORACLE - Rows affected = 1 12 10:09:12 SQL Execute: ORACLE - Commit 13 10:09:12 SQL Data In: ORACLE - Rows affected = 0 14 10:09:12 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 15 10:09:12 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 16 10:09:12 SQL Execute: ORACLE - Select SYSDATE from Dual 17 10:09:12 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 18 10:09:12 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 19 10:09:12 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 20 10:09:12 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 21 10:09:12 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 22 10:09:12 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 23 10:09:32 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 24 10:09:32 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 25 10:09:32 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 26 10:09:32 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 27 10:09:32 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 10:09:32 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 29 10:09:32 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')) 30 10:09:33 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4652520,1114,'wlzx-3','9',nvl('231008446',' '),'192.168.5.33#792:5386@SickBerth.exe+病区护理系统',60) 31 10:09:33 SQL Data In: ORACLE - Rows affected = 1 32 10:09:33 SQL Execute: ORACLE - Commit 33 10:09:33 SQL Data In: ORACLE - Rows affected = 0 34 10:09:33 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 60 35 10:09:33 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 36 10:09:33 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 37 10:09:35 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 38 10:09:35 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 39 10:09:35 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 60 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 40 10:09:35 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 41 10:09:35 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'9'||',')>0 42 10:09:43 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 43 10:09:43 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 44 10:09:43 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 45 10:09:43 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 46 10:09:43 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 47 10:09:43 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 48 10:09:43 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')) 49 10:09:45 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4652521,1114,'wlzx-3','9',nvl('231008446',' '),'192.168.5.33#792:5386@SickBerth.exe+病区护理系统',60) 50 10:09:45 SQL Data In: ORACLE - Rows affected = 1 51 10:09:45 SQL Execute: ORACLE - Commit 52 10:09:45 SQL Data In: ORACLE - Rows affected = 0 53 10:09:45 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 60 54 10:09:45 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 55 10:09:45 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 56 10:09:45 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 57 10:09:45 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 58 10:09:45 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 60 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 59 10:09:45 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 60 10:09:45 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'9'||',')>0 61 10:09:47 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN' 62 10:09:47 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 63 10:09:47 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150611' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',60,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='9') 64 10:09:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 65 10:09:47 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 66 10:09:47 SQL Execute: ORACLE - select sysdate from dual 67 10:09:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='9'))) 68 10:09:47 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 69 10:09:47 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 ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 70 10:09:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 71 10:09:47 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 72 10:09:47 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 73 10:09:47 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 74 10:09:47 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 75 10:09:47 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 76 10:09:47 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 77 10:09:47 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 78 10:09:47 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_ZDYDY_SYHDD','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_SERVERDIRCP','YJ_JSXMSFXZ','BQ_YZZXDDYSFQB','BQ_CQYZZJSSFTXYPSL','YS_ZFBRZFBLYBLB','BQ_YLFYJY_ZYCWXM','ZY_YBDBZJSJK','BLJK_TZYZSFXYHD') 79 10:09:47 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 80 10:09:48 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet','YJ_BBCYHZDPrintSet') and YGBH00 = 1114 81 10:09:48 SQL Execute: ORACLE - select sysdate nowtime from dual 82 10:09:48 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 83 10:09:48 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 84 10:09:48 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='病区消息时间间隔' AND YXBZ00='1' and MC0000='刷新间隔' 85 10:09:48 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 86 10:09:48 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 87 10:09:48 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 88 10:09:48 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 89 10:09:48 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 90 10:09:48 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 91 10:09:48 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 92 10:09:48 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 93 10:09:48 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 94 10:09:48 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 95 10:09:48 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=1114 96 10:09:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 97 10:09:48 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 98 10:09:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1174169.000000 99 10:09:48 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 100 10:09:48 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 101 10:09:48 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 102 10:09:48 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1174169.000000 103 10:09:48 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 104 10:09:48 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 105 10:09:48 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 106 10:09:49 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19450629) AS NL FROM DUAL 107 10:09:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1174169.000000 108 10:09:49 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 109 10:09:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1174169.000000 110 10:09:49 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 111 10:09:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 112 10:10:00 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 113 10:10:00 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','677','62579' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 114 10:10:00 SQL Data In: ORACLE - Rows affected = 1 115 10:10:00 SQL Execute: ORACLE - Commit 116 10:10:00 SQL Data In: ORACLE - Rows affected = 0 117 10:10:00 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 118 10:10:01 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 119 10:10:01 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 120 10:10:01 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 121 10:10:01 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','641','17461' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual 122 10:10:01 SQL Data In: ORACLE - Rows affected = 1 123 10:10:01 SQL Execute: ORACLE - Commit 124 10:10:01 SQL Data In: ORACLE - Rows affected = 0 125 10:10:01 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 126 10:10:01 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 127 10:10:01 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 128 10:10:01 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 129 10:10:03 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '59' 130 10:10:03 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 131 10:10:03 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 132 10:10:03 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 133 10:10:03 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 134 10:10:03 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4652521 135 10:10:03 SQL Data In: ORACLE - Rows affected = 1 136 10:10:03 SQL Execute: ORACLE - Commit 137 10:10:03 SQL Data In: ORACLE - Rows affected = 0 138 10:10:03 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 139 10:10:03 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 140 10:10:03 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')) 141 10:10:04 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4652523,1114,'wlzx-3','9',nvl('231008463',' '),'192.168.5.33#641:17461@SickBerth.exe+病区护理系统',59) 142 10:10:04 SQL Data In: ORACLE - Rows affected = 1 143 10:10:04 SQL Execute: ORACLE - Commit 144 10:10:04 SQL Data In: ORACLE - Rows affected = 0 145 10:10:04 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 59 146 10:10:04 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 147 10:10:04 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 148 10:10:04 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 149 10:10:04 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 150 10:10:04 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 59 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 151 10:10:04 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150611' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',59,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='9') 152 10:10:04 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',59,' )>0 ) and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9') 153 10:10:04 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 154 10:10:04 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 155 10:10:04 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='9') and YXQ000>='20150611' and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',59,' )>0 ) order by XH0000 156 10:10:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 157 10:10:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 158 10:10:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 159 10:10:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 160 10:10:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 161 10:10:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 162 10:11:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 163 10:11:08 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 164 10:11:08 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='9' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='9'))) 165 10:11:09 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||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 166 10:11:09 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 ((1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='0 '))) 167 10:11:09 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 168 10:11:09 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1114= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='+ '))) 169 10:11:09 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 170 10:11:09 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 171 10:11:09 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 172 10:11:09 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 173 10:11:09 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_XZSSSQSFYXKBQ','BQ_KFWYYSFAPCDY','BQ_ZQCYJH') 174 10:11:09 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_ZDYDY_SYHDD','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_HLJLDSFSYFR3DY','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_SFSYXXCSGN','BQ_CWXMSFTSBLSQNJWF','BQ_DYCKDSFQDYJZY','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_YZCXSJSFMRYT','BQ_TSYPYZDY_ZDY','BQ_SFSYPASSXT','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_SERVERDIRCP','YJ_JSXMSFXZ','BQ_YZZXDDYSFQB','BQ_CQYZZJSSFTXYPSL','YS_ZFBRZFBLYBLB','BQ_YLFYJY_ZYCWXM','ZY_YBDBZJSJK','BLJK_TZYZSFXYHD') 175 10:11:09 SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心' 176 10:11:09 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet','YJ_BBCYHZDPrintSet') and YGBH00 = 1114 177 10:11:09 SQL Execute: ORACLE - select sysdate nowtime from dual 178 10:11:09 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 179 10:11:09 SQL Execute: ORACLE - select JMURL0 from bm_jclb00 where rownum=1 180 10:11:09 SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='病区消息时间间隔' AND YXBZ00='1' and MC0000='刷新间隔' 181 10:11:09 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 182 10:11:09 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 183 10:11:09 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59.000000 184 10:11:09 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 185 10:11:09 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 186 10:11:09 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 187 10:11:09 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 188 10:11:09 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 189 10:11:10 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 190 10:11:10 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 191 10:11:10 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=1114 192 10:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 59.000000 193 10:11:10 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 194 10:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1170219.000000 195 10:11:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 196 10:11:10 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 197 10:11:10 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 198 10:11:10 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1170219.000000 199 10:11:10 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 200 10:11:10 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 201 10:11:10 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 202 10:11:10 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19530606) AS NL FROM DUAL 203 10:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1170219.000000 204 10:11:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 205 10:11:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1170219.000000 206 10:11:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 207 10:11:10 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 208 10:11:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 209 10:11:25 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 210 10:11:25 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','1256','9850' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual 211 10:11:25 SQL Data In: ORACLE - Rows affected = 1 212 10:11:25 SQL Execute: ORACLE - Commit 213 10:11:25 SQL Data In: ORACLE - Rows affected = 0 214 10:11:25 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 215 10:11:25 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 216 10:11:25 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 217 10:11:25 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 218 10:11:25 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.5.33','9','SickBerth.exe'||'+'||'病区护理系统','853','34378' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual 219 10:11:26 SQL Data In: ORACLE - Rows affected = 1 220 10:11:26 SQL Execute: ORACLE - Commit 221 10:11:26 SQL Data In: ORACLE - Rows affected = 0 222 10:11:26 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 223 10:11:26 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 224 10:11:26 SQL Execute: ORACLE - Select BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 225 10:11:26 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) order by b.PLXH00,a.BH0000 226 10:11:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 227 10:11:30 SQL Execute: ORACLE - SELECT YYID00 FROM BM_BMBM00 WHERE BMBH00 = '59' 228 10:11:30 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 229 10:11:30 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where 'ly'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 230 10:11:31 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114 231 10:11:31 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 232 10:11:31 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=4652523 233 10:11:31 SQL Data In: ORACLE - Rows affected = 1 234 10:11:31 SQL Execute: ORACLE - Commit 235 10:11:31 SQL Data In: ORACLE - Rows affected = 0 236 10:11:31 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 237 10:11:31 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 238 10:11: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')) 239 10:11:33 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(4652529,1114,'wlzx-3','9',nvl('231008494',' '),'192.168.5.33#853:34378@SickBerth.exe+病区护理系统',59) 240 10:11:33 SQL Data In: ORACLE - Rows affected = 1 241 10:11:33 SQL Execute: ORACLE - Commit 242 10:11:33 SQL Data In: ORACLE - Rows affected = 0 243 10:11:33 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 59 244 10:11:33 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 245 10:11:33 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 246 10:11:33 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33' 247 10:11:33 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 248 10:11:33 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 59 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 249 10:11:33 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20150611' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',59,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='9') 250 10:11:33 SQL Execute: ORACLE - select distinct a.CZYKS0,b.BMMC00 from vw_bm_SystemMessage a,BM_BMBM00 b where a.CZYKS0=b.BMBH00 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',59,' )>0 ) and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9') 251 10:11:33 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='消息系统字体颜色配置' 252 10:11:33 SQL Execute: ORACLE - select * from xt_xtcs00 where name00 = 'XTXXSFJXPX' 253 10:11:33 SQL Execute: ORACLE - select * from vw_bm_SystemMessage where (XTDM00='-1' or XTDM00='9') and YXQ000>='20150611' and XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9') and (JSKSBH is null or instr( ','||JSKSBH||',' , ',59,' )>0 ) order by XH0000 254 10:11:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 255 10:11:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 256 10:11:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 257 10:12:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 258 10:12:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 259 10:12:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 260 10:12:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 261 10:12:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 262 10:12:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 263 10:13:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 264 10:13:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 265 10:13:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 266 10:13:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 267 10:13:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 268 10:13:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 269 10:14:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 270 10:14:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 271 10:14:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 272 10:14:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 273 10:14:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 274 10:14:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 275 10:15:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 276 10:15:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 277 10:15:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 278 10:15:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 279 10:15:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 280 10:15:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 281 10:16:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 282 10:16:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 283 10:16:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 284 10:16:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 285 10:16:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 286 10:16:59 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 287 10:17:09 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 288 10:17:19 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 289 10:17:29 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 290 10:17:39 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00 291 10:17:49 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=59 or DQKS00=59) order by XXID00