1 11:36:58 Log started for: SQL Navigator for Oracle 2 11:37:14 Log started for: 检验信息系统 3 11:37:14 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.102','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','1636','34973' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@505:7C95D110FC31CCD4CBEA82371E5C0B8F' from dual 4 11:37:14 SQL Data In: ORACLE - Rows affected = 1 5 11:37:14 SQL Execute: ORACLE - Commit 6 11:37:14 SQL Data In: ORACLE - Rows affected = 0 7 11:37:14 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 8 11:37:14 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222142' 9 11:37:14 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='505' and CZBZ00 in ('1') 10 11:37:14 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 11 11:37:14 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.1.102','J','PrjLIS_LIS.exe'||'+'||'检 验 管 理 系 统','1469','36175' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@505:0DA32976C46B3AAF10A9CE8307610BF2' from dual 12 11:37:14 SQL Data In: ORACLE - Rows affected = 1 13 11:37:14 SQL Execute: ORACLE - Commit 14 11:37:14 SQL Data In: ORACLE - Rows affected = 0 15 11:37:14 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 16 11:37:14 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='505' and CZBZ00 in ('1') 17 11:37:14 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='XT_SFKQCADLYZ' 18 11:37:14 SQL Execute: ORACLE - select nvl(SFSDYH,'0') from BM_YGBM00 where XKH000='505' 19 11:37:14 SQL Execute: ORACLE - Select SYSDATE from Dual 20 11:37:14 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 21 11:37:14 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 22 11:37:14 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 23 11:37:14 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 24 11:37:14 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 25 11:37:14 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='505')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='505')) order by b.PLXH00,a.BH0000 26 11:37:15 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '505'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='505')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='505') 27 11:37:15 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1726 28 11:37:15 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 29 11:37:15 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 30 11:37:15 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 31 11:37:15 SQL Execute: ORACLE - select SID,SERIAL# from V$session where AUDSID='368955804' 32 11:37:15 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 33 11:37:15 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where SID000='1469' and SERIAL='36175' 34 11:37:15 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(1941806,1726,'5BDB8DCGP0W94QV','J',nvl('368955804',' '),'192.168.6.100-192.168.1.102#1469:36175@PrjLIS_LIS.exe+检 验 管 理 系 统',483) 35 11:37:15 SQL Data In: ORACLE - Rows affected = 1 36 11:37:15 SQL Execute: ORACLE - Commit 37 11:37:15 SQL Data In: ORACLE - Rows affected = 0 38 11:37:15 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 483 39 11:37:15 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222142' 40 11:37:15 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 41 11:37:15 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.1.102' 42 11:37:15 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 43 11:37:15 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 483 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 44 11:37:15 SQL Execute: ORACLE - select FSBYJ0 from BM_CKBM00 where BMBH00= 483 and FLAG00 like '%' and CKBH00='60' 45 11:37:15 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222142') 46 11:37:15 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where (nvl(a.YYID00,'0')='222142' or trim(nvl(a.YYID00,'0'))='0') AND (a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'J'||',')>0 ) 47 11:37:17 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1726' and name00='SYSTEMSKIN' 48 11:37:17 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 49 11:37:17 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20210428' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',483,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='J') 50 11:37:17 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') and (SYXT00='999' or instr(','||SYXT00||',',',J,')>0 ) 51 11:37:17 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 52 11:37:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 电子虚拟健康卡 53 11:37:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 54 11:37:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 55 11:37:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 56 11:37:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Open_MZ 57 11:37:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 58 11:37:17 SQL Execute: ORACLE - select * from XT_XTCS00 where NAME00='XT_SQLPLUSSECURLEVEL' 59 11:37:17 SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00='SQL注入关键字配置' order by XSXH00 60 11:37:17 SQL Execute: ORACLE - select trim(VALUE0) VALUE0 from XT_XTCS00 where name00='XT_YBKDKFS' 61 11:37:17 SQL Execute: ORACLE - select sysdate from dual 62 11:37:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 一卡通平台参数 63 11:37:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = SF_SFQYYKTPT 64 11:37:17 SQL Execute: ORACLE - select SF_SF_TYZD00(?,?)FHJG00 from dual 65 11:37:17 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT','JYHZDPRT','JYZLXMPRT') and YGBH00 = 1726 66 11:37:17 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_JY_%' AND STATUS<>'VALID' 67 11:37:17 SQL Execute: ORACLE - select * from vw_jy_tjks00 where BMBH00 = 483 68 11:37:17 SQL Execute: ORACLE - select QZ0000 from JY_SGCJZD where dqzy00='Y' 69 11:37:17 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'J' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 70 11:37:17 SQL Execute: ORACLE - select * from xt_xtcs00 where NAME00 like 'JY_%' or NAME00 = 'YS_ZHXMXZ' 71 11:37:17 SQL Execute: ORACLE - select BH0000,MC0000,WBSM00 from BM_TYZD00 where ZDMC00='系统登录版本设置' and BH0000 in('J') and YXBZ00='1' 72 11:37:17 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='J' and (( 1726= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1726 and XTDM00='J'))) 73 11:37:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'J$%' and A.XTDM00='J' and trim(A.MKDM00)='J$'||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 74 11:37: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 ((1726= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1726 and XTDM00='0 '))) 75 11:37:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 76 11:37:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1726= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1726 and XTDM00='+ '))) 77 11:37:18 SQL Execute: ORACLE - select count(*) from VW_JY_YGQXZD where yqdh00='00' and qxlx00='XTQX' and QXGNDH='YSYQSJ' and ygbh00=1726 78 11:37:18 SQL Execute: ORACLE - select count(*) from JY_SJB000 where SYBZ00='Y' and DQKCL0-YCKSL0 0 AND A.YXRQ00 < TO_CHAR(SYSDATE+A.SXTQTS,'YYYYMMDD') AND B.SYBZ00 = 'Y' 80 11:37:18 SQL Execute: ORACLE - select count(*) from JY_SBGLWH where zhwhrq < TO_CHAR(SYSDATE-ZXWHJG,'YYYYMMDD') AND ZXWHJG<>'0' 81 11:37:18 SQL Execute: ORACLE - select count(*) from (select SF_JY_GETTATZZSJ(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ, BBSDRQ,BBSDSJ,MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,'-1') SFCTAT from VW_JY_YW0000 where JGZT00||'A' in ('1A','2A','4A','5A') and BBCYRQ between '20210425' and '20210428') t where SFCTAT in ('Y','M') 82 11:37:18 SQL Execute: ORACLE - select SYSJ00,BRXM00,DECODE(MZZYBZ,'0','门诊','住院') BRLX00,ZYHGHH,TXM000,ZLXMJC, decode(JGZT00,'1','已采集','2','已签收','4','已排样','5','已处理') JGZT01, decode(YXBZ00,'Y','是','N','否') SFJZ00,BBCYRQ,BBCYSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00 from (select JYYWID,BRXM00,ZYHGHH,TXM000,MZZYBZ,SFTJ00,YXBZ00,ZLXMID, ZLXMJC,JGZT00,BBCYRQ,BBCYSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00, substrb(SF_JY_GETTATZZSJ(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ, BBSDSJ,MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,'0'),1,200) SYSJ00 from VW_JY_YW0000 where JGZT00||'A' in ('1A','2A','4A','5A') and BBCYRQ between '20210425' and '20210428') C where SYSJ00<>'N' order by BBCYRQ 83 11:37:20 SQL Execute: ORACLE - select count(*) from VW_JY_YGQXZD where yqdh00='00' and qxlx00='XTQX' and QXGNDH='JYJSWHQX' and ygbh00=1726 84 11:37:20 SQL Execute: ORACLE - select * from (select PYRQ00,YQDH00,count(1) count0 from JY_YW0000 A where PYRQ00 between '20210329' and '20210427' and JGZT00||'A' in ('4A','5A') and BGR000=1726group by PYRQ00,YQDH00) where rownum<=5 85 11:37:29 SQL Execute: ORACLE - select VALUE0,DM0000 from xt_zd0000 where zdbm00='BBTHYY' and yxbz00='1'