1 14:40:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 2 14:40:34 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,GJBM00,JSXM00,FYMC00,BZ0000 from vw_yj_yysfxm where (pysm00 Like ?) and( ((JSXM00='0') or (JSXM00='1' and ('210101002' Like GJBM00||'%')) or (JSXM00='2' and Instr('950058,950059',substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ')) ) Order By pysm00) where Rownum<=30 3 14:40:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = y% 4 14:40:44 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,GJBM00,JSXM00,FYMC00,BZ0000 from vw_yj_yysfxm where (pysm00 Like ?) and( ((JSXM00='0') or (JSXM00='1' and ('210101002' Like GJBM00||'%')) or (JSXM00='2' and Instr('950058,950059',substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ')) ) Order By pysm00) where Rownum<=30 5 14:40:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = yc% 6 14:40:50 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,GJBM00,JSXM00,FYMC00,BZ0000 from vw_yj_yysfxm where (pysm00 Like ?) and( ((JSXM00='0') or (JSXM00='1' and ('210101002' Like GJBM00||'%')) or (JSXM00='2' and Instr('950058,950059',substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ')) ) Order By pysm00) where Rownum<=30 7 14:40:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ycx% 8 14:40:50 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,GJBM00,JSXM00,FYMC00,BZ0000 from vw_yj_yysfxm where (pysm00 Like ?) and( ((JSXM00='0') or (JSXM00='1' and ('210101002' Like GJBM00||'%')) or (JSXM00='2' and Instr('950058,950059',substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ')) ) Order By pysm00) where Rownum<=30 9 14:40:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = ycxs% 10 14:40:50 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,GJBM00,JSXM00,FYMC00,BZ0000 from vw_yj_yysfxm where (pysm00 Like ?) and( ((JSXM00='0') or (JSXM00='1' and ('210101002' Like GJBM00||'%')) or (JSXM00='2' and Instr('950058,950059',substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ')) ) Order By pysm00) where Rownum<=30 11 14:40:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ycxsy% 12 14:40:51 SQL Execute: ORACLE - Select * from (select xmmc00,sfxmid,bh0000,pysm00,wbsm00,sfje00,GJBM00,JSXM00,FYMC00,BZ0000 from vw_yj_yysfxm where (pysm00 Like ?) and( ((JSXM00='0') or (JSXM00='1' and ('210101002' Like GJBM00||'%')) or (JSXM00='2' and Instr('950058,950059',substrb(BH0000,1,6))>0)) and (FYID00=rpad('0',6,' ')) ) Order By pysm00) where Rownum<=30