1       20:36:56  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = jqzz1%
2       20:36:56  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170817
3       20:36:56  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170817
4       20:36:56  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2017081700:00:00
5       20:36:56  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2017081723:59:59
6       20:36:56  SQL Execute: ORACLE - select  C.WBHLMC,B.PJXH00,B.PLMC00,(select brxm00 from bm_brxxb0 d where d.brid00=a.brid00) XM0000 
,A.*  from  sf_brjfb0 A,SF_PJSYQK B,BM_WBHLB0 C  where  A.PJH000 = B.PJH000(+)  and  A.WBHLID = C.WBHLID  and  A.JFJE00 <> 0 
 and  exists( select 1 from  bm_ygbm00 where ygbh00 = A.jfczy0 and xkh000 like ? ) 
 and  A.JFRQ00 >=?  and  A.JFRQ00 <=?   and  A.JFRQ00||A.JFSJ00 >= ?    and  A.JFRQ00||A.JFSJ00 <= ? 
 and  A.ZFFS00 = 1 
 order by A.DJH000