避免selet into的no_data_found

 

declare

v_rdc_id number;

begin

select nvl(sum(rdc_id),0)  into v_rdc_id  from rdc t where 1=2;  

---- 先聚合，再取nvl后。即使中间返回0条记录，也不会no_data_found

end;