[size=medium]在写存储过程时,遇到if语句不支持子查询 问题,
IF (sysdate - 1) NOT IN (SELECT STATISTIC_DATE FROM HNM_TRAFFICFLOW_DAY) THEN
......
......
......
解决方法:
将条件单独拿出
定义一个变量 bool
select case when (sysdate - 1) NOT IN (SELECT STATISTIC_DATE FROM HNM_TRAFFICFLOW_DAY) then 'YES' end into bool from dual
IF bool='YES' THEN
......
......
......[/size]
IF (sysdate - 1) NOT IN (SELECT STATISTIC_DATE FROM HNM_TRAFFICFLOW_DAY) THEN
......
......
......
解决方法:
将条件单独拿出
定义一个变量 bool
select case when (sysdate - 1) NOT IN (SELECT STATISTIC_DATE FROM HNM_TRAFFICFLOW_DAY) then 'YES' end into bool from dual
IF bool='YES' THEN
......
......
......[/size]