declare
v_fswsl number(10);
v_fswmj number;
begin
/*但是如果没有附和t.fsw='有' 条件的记录的话，存储过程直接触发no_DATA_FOUND异常。我希望如果该统计结果为空（没有符合条件的记录集），就将NULL插入，请问如何实现呢？*/
   SELECT COUNT(*) as t_sl,SUM(t.mj) as t_mj INTO v_fswsl,v_fswmj FROM FD t WHERE t.fsw='有' and t.zl=11 GROUP BY t.zl;
   INSERT into log_table(info,curdate) values(to_char(v_fswmj),sysdate);
--exception
--WHEN no_data_found  THEN 
END;

SELECT COUNT(*)  INTO v_fswsl  FROM FD t WHERE t.fsw='有' and t.zl=11 GROUP BY t.zl;
if v_fswsl>0 then
 SELECT COUNT(*) as t_sl,SUM(t.mj) as t_mj INTO v_fswsl,v_fswmj FROM FD t WHERE t.fsw='有' and t.zl=11 GROUP BY t.zl;    else
 v_fswsl:=0;
END if;