begin begin select ...... exception when no_data_found then --找不数据的判断 select ... end; exception when others then raise ; end; /
begin begin select ...... exception when no_data_found then --找不数据的判断 select ... end;exception when others then raise ; end;
begin begin select ...... exception when no_data_found then --找不数据的判断 select ... end; select ... ----这里no_data_found的时候时候不要执行的exception when others then raise ; end;
begin
select ......
exception
when no_data_found then --找不数据的判断
select ...
end;
exception
when others then
raise ;
end;
/
begin
select ......
exception
when no_data_found then --找不数据的判断
select ...
end;exception
when others then
raise ;
end;
begin
select ......
exception
when no_data_found then --找不数据的判断
select ...
end;
select ... ----这里no_data_found的时候时候不要执行的exception
when others then
raise ;
end;