系统例外

系统例外：no_data_found

--系统例外：no_data_found
declare
  pename emp.ename%type;
begin
  select ename into pename from emp WHERE empno = 1234;
exception
  when no_data_found then
    dbms_output.put_line('没有找到该员工');
  when others then
    dbms_output.put_line('其他例外');
end;

系统例外：too_many_rows

--系统例外：too_many_rows
declare
  pename emp.ename%type;
begin
  select ename into pename from emp WHERE deptno = 10;
exception
  when too_many_rows then
    dbms_output.put_line('select语句匹配多个行');
  when others then
    dbms_output.put_line('其他例外');
end;

系统例外：zero_divide

--系统例外：zero_divide
declare
  pnum number;
begin
  pnum :=1/0;
exception
  when zero_divide then
    dbms_output.put_line('0不能做除数');
  when others then
    dbms_output.put_line('其他例外');
end;

系统例外：value_error

--系统例外：value_error
declare
  pnum number;
begin
  pnum :='abc';
exception
  when value_error then
    dbms_output.put_line('数据类型错误');
  when others then
    dbms_output.put_line('其他例外');
end;