1 10:02:39 SQL Prepare: ORACLE - select * from VW_BQ_JRZLYZ a where BQH000=482 and zyid00 in (329977) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 2 10:02:39 SQL Execute: ORACLE - select * from VW_BQ_JRZLYZ a where BQH000=482 and zyid00 in (329977) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid