在给str :=
'select p.CATENAME,p.PROD_PIC,p.UP_TIME ,p.PROD_NAME,p.STATEPAGE,m.MTOWN,m.MTEL_CODE from SYS_PROD_INFO p join sys_member m on p.MEMBERID=m.MEMBERID where p.UP_TIME>=p.UP_TIME>=(TO_DATE (TO_CHAR (SYSDATE, ''yyyy-MM-dd''), ''yyyy-MM-dd'')-1) and p.CATECODE='''||sys_catecode||''''; 'select p.CATENAME,p.PROD_PIC,p.
'select p.CATENAME,p.PROD_PIC,p.UP_TIME ,p.PROD_NAME,p.STATEPAGE,m.MTOWN,m.MTEL_CODE from SYS_PROD_INFO p join sys_member m on p.MEMBERID=m.MEMBERID where p.UP_TIME>=p.UP_TIME>=(TO_DATE (TO_CHAR (SYSDATE, ''yyyy-MM-dd''), ''yyyy-MM-dd'')-1) and p.CATECODE='''||sys_catecode||''''; 'select p.CATENAME,p.PROD_PIC,p.
