只写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;