1       14:35:56  SQL Data In: ORACLE - Rows affected = 0
2       14:35:56  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170401
3       14:35:56  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170430
4       14:35:56  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
5       14:35:56  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
6       14:35:56  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000
7       14:35:56  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
8       14:35:56  SQL Data In: ORACLE - Param = 7, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
9       14:35:56  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170401
10      14:35:56  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170430
11      14:35:56  SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
12      14:35:56  SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
13      14:35:56  SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 55.000000
14      14:35:56  SQL Data In: ORACLE - Param = 13, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
15      14:35:56  SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
16      14:35:56  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

17      14:37:26  Log started for: SQL Navigator for Oracle