1       16:45:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230325
2       16:45:40  SQL Execute: ORACLE -  select TO_CHAR(TO_DATE(?,'YYYYMMDD') - 1,'YYYYMMDD') FROM DUAL 

3       16:45:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230326
4       16:45:40  SQL Execute: ORACLE -  select TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD') FROM DUAL 

5       16:45:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230325
6       16:45:40  SQL Execute: ORACLE -  select TO_CHAR(TO_DATE(?,'YYYYMMDD'),'YYYYMMDD') FROM DUAL 

7       16:45:40  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2272.000000
8       16:45:40  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230324
9       16:45:40  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230326
10      16:45:40  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230325
11      16:45:40  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00
12      16:45:40  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230326
13      16:45:40  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00
14      16:45:40  SQL Execute: ORACLE - select a.* from VW_YF_DDJZYDJCF a where 1=1 and a.YFBMBH+0=? 
 and a.FYRQ00 between ? and ?  and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? 

15      16:45:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230325
16      16:45:48  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230326
17      16:45:48  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230325
18      16:45:48  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00
19      16:45:48  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20230326
20      16:45:48  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13:00:00
21      16:45:48  SQL Execute: ORACLE - select a.* from VW_YF_JYXXB0 a where 1=1 
 and a.KDJFRQ between ? and ?  and a.KDJFRQ||a.KDJFSJ between ? || ? and ? || ? 
 and nvl(a.SYRQ00,'20991231')='20991231' 
 order by a.JYDH00 desc 

22      16:45:49  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 43055595
23      16:45:49  SQL Execute: ORACLE - select a.*,a.CFDW00 as QLDW00 from YF_MZCFMX a where a.CFLSH0=?