select 判断数据是否存在,若存在,将值赋给变量
declare temp varchar2(1000);begin select nvl((select t.data from err_traffic t where rownum = 1), '0') into temp from dual; dbms_output.put_line(temp);end;这样免去了 先用sel