1       10:18:10  Log started for: 药房显示系统
2       10:18:10  SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# 
from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

3       10:18:10  SQL Execute: ORACLE -  Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.6.224','Z',trim(PROGRAM)||'+'||'显示屏系统',SID,serial# ,'20181009','10:18:21','scott@0:C0324AED7E799E98058027B34CD8ED15' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1)

4       10:18:10  SQL Data In: ORACLE - Rows affected = 1
5       10:18:10  SQL Execute: ORACLE - Commit

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

8       10:18:10  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222142'

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

10      10:18:10  SQL Data In: ORACLE - Rows affected = 1
11      10:18:10  SQL Execute: ORACLE - Commit

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

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

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

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

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

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

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

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

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