只写if V_NUM=4 then 执行SQL可以运行修改字段, if (V_NUM=4 AND V_STATUS='NO') 条件这样写,就没有修改成功,是为什么呢 create or replace procedure market_procedure is V_NUM NUMBER; V_STATUS VARCHAR2(100); begin select count(STATUS) INTO V_NUM from DIM_STOCK_switch where rq = (select max(statistic_date) from ods_stock_market_detail) AND STATUS = 'YES'; SELECT STATUS INTO V_STATUS FROM olap_table_switch_0410 where SWITCHNAME = 'stock_market'; if (V_NUM=4 AND V_STATUS='NO') then update olap_table_switch_0410 set status='YES' , DATATIME_LASTCHANGE=SYSDATE where SWITCHNAME='stock_market'; commit; end if; end; |