动态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;

 

posted on 2015-01-22 14:50  braveliu  阅读(989)  评论(1编辑  收藏  举报

qzone: welcome to my qzone github:welcome to my github mail:contact me with gmail