动态SQL select into语句报错

oracle动态SQL里不能直接写:

dynamicCSRQSQL:='  SELECT count(1) CSRQISNULL into CSRQ_NULL FROM WJW_POPULATION_'||table_suffix||' t 
 WHERE NVL(csrq,TO_DATE("1000/1/1","YYYY/MM/DD"))=TO_DATE("1000/1/1","YYYY/MM/DD")';
Execute immediate  dynamicCSRQSQL;

正确的写法是:

dynamicCSRQSQL:='  SELECT count(1) CSRQISNULL  FROM WJW_POPULATION_'||table_suffix||' t 
 WHERE NVL(csrq,TO_DATE("1000/1/1","YYYY/MM/DD"))=TO_DATE("1000/1/1","YYYY/MM/DD")';
 Execute immediate  dynamicCSRQSQL into CSRQ_NULL;
原文地址:https://www.cnblogs.com/braveliuchina/p/4241675.html