Oracle数据库select into无结果返回时异常处理_m0_37845840的博客_oracle查询无结果返回空

如下写法如果test_menu查不到数据时会出现异常

select t.menu_id,
       t.menu_name 
  into V_MENU_ID,
       V_MENU_NAME
from test_menu t 
     where 1=1 and t.menu_id = :new.menu_id;select t.menu_id,