1       16:38:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170401
2       16:38:25  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170430
3       16:38:25  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
4       16:38:25  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
5       16:38:25  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.000000
6       16:38:25  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
7       16:38:25  SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
8       16:38:25  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170401
9       16:38:25  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170430
10      16:38:25  SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
11      16:38:25  SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
12      16:38:25  SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.000000
13      16:38:25  SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
14      16:38:25  SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
15      16:38:25  SQL Execute: ORACLE - select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 from(select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') and (a.mzzybz=? or (2=?))  and a.yjksbh+0=? and  ((b.brfb00=?) or  (-1=?)) union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') and (a.mzzybz=? or (2=?))  and a.yjksbh+0=? and  ((b.brfb00=?) or (-1=?)) ) y group by zlxmid)z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid

16      17:00:17  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0)=upper('sd_hospital')  and ROWNUM = 1