begin
select distinct lilbz
into lv_llbz
from yd_yonghdj
where huh=lv_hh and lilbz is not null ;
exception
when no_data_found then
...
end;
执行时,要是没有符合条件的记录时,会跳到when no_data_found then,
可以考虑,在...处写代码
select distinct lilbz
into lv_llbz
from yd_yonghdj
where huh=lv_hh and lilbz is not null ;
exception
when no_data_found then
...
end;
执行时,要是没有符合条件的记录时,会跳到when no_data_found then,
可以考虑,在...处写代码
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货