1       10:13:40  Log started for: 药房显示系统
2       10:13:40  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.6.13','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20170623','10:20:41','scott@0:C0324AED7E799E98058027B34CD8ED15' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

3       10:13:40  SQL Data In: ORACLE - Rows affected = 1
4       10:13:40  SQL Execute: ORACLE - Commit

5       10:13:40  SQL Data In: ORACLE - Rows affected = 0
6       10:13:40  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

7       10:13:40  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222142'

8       10:13:40  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.6.13','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20170623','10:20:41','sd_hospital@0:0' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

9       10:13:40  SQL Data In: ORACLE - Rows affected = 1
10      10:13:40  SQL Execute: ORACLE - Commit

11      10:13:40  SQL Data In: ORACLE - Rows affected = 0
12      10:13:40  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

13      10:13:40  SQL Execute: ORACLE -  select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=3
 and rownum=1

14      10:13:40  SQL Execute: ORACLE -  select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=4
 and rownum=1

15      10:13:40  SQL Execute: ORACLE -  select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=5
 and rownum=1

16      10:13:40  SQL Execute: ORACLE -  select CKMC00 from BM_CKBM00 where FLAG00 in('3','4') and DQXSP0=6
 and rownum=1

17      10:13:44  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(6),1,1000)),'') XSPXS0 from dual where rownum=1

18      10:13:44  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(5),1,1000)),'') XSPXS0 from dual where rownum=1

19      10:13:44  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(4),1,1000)),'') XSPXS0 from dual where rownum=1

20      10:13:44  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(3),1,1000)),'') XSPXS0 from dual where rownum=1

21      10:13:47  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(6),1,1000)),'') XSPXS0 from dual where rownum=1

22      10:13:47  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(5),1,1000)),'') XSPXS0 from dual where rownum=1

23      10:13:50  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(6),1,1000)),'') XSPXS0 from dual where rownum=1

24      10:13:50  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(5),1,1000)),'') XSPXS0 from dual where rownum=1

25      10:13:53  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(6),1,1000)),'') XSPXS0 from dual where rownum=1

26      10:13:53  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(5),1,1000)),'') XSPXS0 from dual where rownum=1

27      10:13:53  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(3),1,1000)),'') XSPXS0 from dual where rownum=1

28      10:13:53  SQL Execute: ORACLE - select nvl(rtrim(substrb(sf_xspxs(4),1,1000)),'') XSPXS0 from dual where rownum=1