1       09:29:58  Log started for: SQL Navigator for Oracle
2       09:40:15  Log started for: 健康体检系统
3       09:40:15  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

4       09:40:15  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','655','56290' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ly:E5DD2EC9027205BC04C2E3B7F12B9065' from dual

5       09:40:15  SQL Data In: ORACLE - Rows affected = 1
6       09:40:15  SQL Execute: ORACLE - Commit

7       09:40:15  SQL Data In: ORACLE - Rows affected = 0
8       09:40:15  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       09:40:15  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

10      09:40:15  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

11      09:40:15  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

12      09:40:15  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.5.33','T','MedicalExa.exe'||'+'||'健康体检系统','1036','50998' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@ly:26F1C9ADF334D1F039F36CD55C521202' from dual

13      09:40:15  SQL Data In: ORACLE - Rows affected = 1
14      09:40:15  SQL Execute: ORACLE - Commit

15      09:40:15  SQL Data In: ORACLE - Rows affected = 0
16      09:40:15  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='T'

17      09:40:15  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='LY' and CZBZ00 in ('1') 

18      09:40:15  SQL Execute: ORACLE - Select SYSDATE from Dual

19      09:40:15  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

20      09:40:15  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

21      09:40:15  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='T'

22      09:40:15  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

23      09:40:15  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

24      09:40:15  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='T'
 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 ('0','1','2','3','4','5','6','7','8','9')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='T'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY'))
 order by b.PLXH00,a.BH0000

25      09:40:15  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'ly'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'T' 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='T' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='LY') 

26      09:40:15  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1114

27      09:40:15  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

28      09:40:15  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

29      09:40:15  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

30      09:40:15  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

31      09:40:15  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'))

32      09:40:17  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(4631599,1114,'wlzx-3','T',nvl('230860569',' '),'192.168.5.33#1036:50998@MedicalExa.exe+健康体检系统',125)

33      09:40:17  SQL Data In: ORACLE - Rows affected = 1
34      09:40:17  SQL Execute: ORACLE - Commit

35      09:40:17  SQL Data In: ORACLE - Rows affected = 0
36      09:40:17  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 125

37      09:40:17  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

38      09:40:17  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

39      09:40:17  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.5.33'

40      09:40:17  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

41      09:40:17  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
125 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

42      09:40:17  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

43      09:40:17  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'T'||',')>0 

44      09:40:19  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1114' and name00='SYSTEMSKIN'

45      09:40:19  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

46      09:40:19  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20150527'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',125,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='T')

47      09:40:19  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

48      09:40:19  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

49      09:40:19  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='T' and (( 
1114= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1114 and XTDM00='T'))) 

50      09:40:19  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'T$%' and A.XTDM00='T' and trim(A.MKDM00)='T$'||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

51      09:40:19  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 '))) 

52      09:40:19  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

53      09:40:19  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='+ '))) 

54      09:40:19  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_TJ_%' AND STATUS<>'VALID'

55      09:40:19  SQL Execute: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_TJ_%'

56      09:40:19  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYDPRINTER','BGDPRINTER','TXMPRINTER','RYPRINTER') and YGBH00 = '1114'

57      09:40:19  SQL Execute: ORACLE - SELECT NAME00, SF_TJ_GETXTCS('222137', VALUE0) VALUE0 FROM XT_XTCS00 WHERE NAME00 LIKE 'TJ_%'

58      09:40:19  SQL Execute: ORACLE - SELECT SF_TJ_GETXTCS('222137', VALUE0) value0,name00 FROM XT_XTCS00 WHERE NAME00 IN ('XT_GZYJJYXTJK','SF_COMMIT_READICK','SF_SFGLGZGHD','XT_MZJYJK','SF_FPLXBZ0','SF_PJHSC0','SF_SFSYJZK','SF_SYDJSBBGBF','XT_SGLRKH','SF_KHBLHXT','YJ_TXMQJZM','BQ_TMPrinterM','YJ_ZDYMBID','YS_PACSTWBGWZ','XT_PACSCJDM','YS_PACSTXLLWZ')

59      09:40:19  SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'T' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00')

60      09:40:26  SQL Execute: ORACLE - select * from TJ_TCWH00 WHERE YYID00 = '222137' order by XSSX00 

61      09:40:26  SQL Execute: ORACLE - select SUM(C.SFJE00*D.SFCS00) from BM_YYSFXM C,XT_ZLSFGX D,VW_TJ_YWMXXM E,TJ_TCXMWH F WHERE C.SFXMID=D.SFXMID AND D.ZLXMID=E.ZXMID0 AND D.FJFYBZ='N' AND E.SJXMID=F.ZLXMID AND F.TCBH00='201'

62      09:40:26  SQL Execute: ORACLE - Select A.ZLXMID,B.ZLXMJC,C.YYID00 from TJ_TCXMWH A,BM_ZLZD00 B, TJ_TCWH00 C WHERE A.tcbh00='201' AND A.ZLXMID=B.ZLXMID AND A.TCBH00 = C.TCBH00 AND C.YYID00 = '222137' order by A.XH0000

63      09:40:26  SQL Execute: ORACLE - Select distinct B.ZLXMID,B.ZLXMJC from VW_TJ_ZHXM00_0 B where B.ZLXMID not in (select ZLXMID from TJ_TCXMWH WHERE tcbh00='201') AND B.YYID00 = '222137' 
 order by zlxmjc 

64      09:41:41  SQL Execute: ORACLE - select NVL(max(xh0000),0)+1 from TJ_TCXMWH where TCBH00=201

65      09:41:41  SQL Execute: ORACLE - insert into TJ_TCXMWH(TCBH00,ZLXMID,XH0000) values('201','22606','5')

66      09:41:41  SQL Data In: ORACLE - Rows affected = 1
67      09:41:41  SQL Execute: ORACLE - commit

68      09:41:41  SQL Data In: ORACLE - Rows affected = 0
69      09:41:41  SQL Execute: ORACLE - Select A.ZLXMID,B.ZLXMJC,C.YYID00 from TJ_TCXMWH A,BM_ZLZD00 B, TJ_TCWH00 C WHERE A.tcbh00='201' AND A.ZLXMID=B.ZLXMID AND A.TCBH00 = C.TCBH00 AND C.YYID00 = '222137' order by A.XH0000

70      09:41:41  SQL Execute: ORACLE - Select distinct B.ZLXMID,B.ZLXMJC from VW_TJ_ZHXM00_0 B where B.ZLXMID not in (select ZLXMID from TJ_TCXMWH WHERE tcbh00='201') AND B.YYID00 = '222137' 
 order by zlxmjc 

71      09:41:41  SQL Execute: ORACLE - select SUM(C.SFJE00*D.SFCS00) from BM_YYSFXM C,XT_ZLSFGX D,VW_YS_YWMXXM E,TJ_TCXMWH F WHERE C.SFXMID=D.SFXMID AND D.ZLXMID=E.ZXMID0 AND E.SJXMID=F.ZLXMID AND F.TCBH00='201'