1       08:28:44  SQL Execute: ORACLE - update JY_YW0000 A set TMDYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),TMDYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),BBCYRQ=TO_CHAR(SYSDATE,'YYYYMMDD'),BBCYSJ=TO_CHAR(SYSDATE,'HH24:MI:SS'),jgzt00='1',TMDYR0='2' where   YJDJH0 in ('0','7726313','7726314') and BBCYRQ IS NULL AND JGZT00='0'

2       08:28:44  SQL Data In: ORACLE - Rows affected = 0
3       08:28:44  SQL Execute: ORACLE - commit

4       08:28:44  SQL Data In: ORACLE - Rows affected = 0
5       08:28:44  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('MZTXMPRT')
 and YGBH00 = 2

6       08:28:44  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 in ('JY_MZTMDYYLSFGXJGZT')

7       08:28:44  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_TXMHZDXMMCCD')

8       08:28:44  SQL Execute: ORACLE - select trim(value0) from xt_xtcs00 where name00 in ('JY_MZTXMDYSFXRCJR')

9       08:28:44  SQL Execute: ORACLE - select trim(value0) from xt_xtcs00 where name00 in ('JY_TXMHZDSFZDYXMBRXX')

10      08:28:44  SQL Execute: ORACLE - select length(XMMC00) from (select BRXM00,XB0000,NL0000,txm000 ,ZYHGHH,SF_GET_JYTMDYXX('ZLXMMC','select XMMC00 from (select distinct TXM000,XMMC00 from VW_JY_TXMCJD a  where YJDJH0 in (0,0,7726313,7726314) and KDRQ00+0>=to_char(sysdate-180,''YYYYMMDD''))') XMMC00,TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI') CYRQSJ , (select qdsj00 from vw_jy_QDPZ00 where yjdjh0 = a.yjdjh0 and nvl(txm000,'0')=nvl(a.txm000,'0') and rownum=1) qdsj00 from VW_JY_TXMCJD a  where YJDJH0 in('0','7726313','7726314') and KDRQ00+0>=to_char(sysdate-180,'YYYYMMDD') and rownum=1 )

----说明：上面这段比较很慢，测试改为“SELECT length(sf_get_jytmdyxx
                  ('ZLXMMC',
                   'select XMMC00 from (select distinct TXM000,XMMC00 from VW_JY_TXMCJD a  where YJDJH0 in (0,0,7726313,7726314) and KDRQ00+0>=to_char(sysdate-180,''YYYYMMDD''))'
                  )) xmmc00   
          FROM vw_jy_txmcjd a
         WHERE yjdjh0 IN ('0', '7726313', '7726314')
           AND kdrq00 + 0 >= TO_CHAR (SYSDATE - 180, 'YYYYMMDD')
           AND ROWNUM = 1”速度很快，修正归档到160316版本

11      08:30:37  SQL Execute: ORACLE - select DISTINCT ZYGHID ZYID00,BRXM00,XB0000,NL0000,TXMMC0,(select qdsj00 from vw_jy_QDPZ00 where yjdjh0 = a.yjdjh0 and nvl(txm000,'0')=nvl(a.txm000,'0') and rownum=1) qdsj00,(select ddmc00 from vw_jy_QDPZ00 where yjdjh0 = a.yjdjh0 and nvl(txm000,'0')=nvl(a.txm000,'0') and  rownum=1) ddmc00,DECODE(BBCYRQ,NULL,'打印','补打') JBXX01,TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI') CYRQSJ,BBMC00, CH0000,txm000,XMMC00,YBTJ00,BRLB00,BMMC00,ZYHGHH, nvl((select SQYS00 from JY_YW0000  where txm000=a.txm000 and rownum=1),a.sqys00) sqys00, nvl((select d.ZWXM00 from JY_YW0000 c,BM_YGBM00 d  where c.sqys00=d.YGBH00 and c.txm000=a.txm000 and rownum=1),a.sqysxm) sqysxm  from VW_JY_TXMCJD a  where YJDJH0 in('0','7726313','7726314') and KDRQ00+0>=to_char(sysdate-180,'YYYYMMDD')