系统例外: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;