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);
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;
这样免去了 先用select count(*) 判断,这用查询一次就可以