个回答

• Tomorrow明天

  2018-07-15 21:21:44

  set serveroutput on

  declare

      cursor c is select name from tb_1 where id=5;

      pname tb_1.name%type;

      not_found_emp exception;

  begin

  open c;

  
  

  fetch c into pname;

  
  

  if c%notfound then

      raise not_found_emp;

  end if;

  
  

  close c;

  
  

  exception

  when not_found_emp then DBMS_OUTPUT.PUT_LINE('没有找到5号员工');

  when others then dbms_output.put_line('其他例外');

  close c;

  end;

  /

  
  

  0