oracle plsql异常,oracle plsql 异常

set serveroutput on

DECLARE

pename emp.ename%type;

begin

select ename into pename from emp where ename='1213';

exception

when

no_data_found then dbms_output.put_line('没有该数据');

when

others then dbms_output.put_line('其他exception');

end;

set serveroutput on

DECLARE

pename emp.ename%type;

begin

select ename into pename from emp where ename='1213';

exception

when

no_data_found then dbms_output.put_line('没有该数据');

when

others then dbms_output.put_line('其他exception');

end;

set serveroutput on

DECLARE

pnum number;

begin

pnum:=1/0;

exception

when

zero_divide then dbms_output.put_line('0不能做除数');

when

others then dbms_output.put_line('其他exception');

end;

set serveroutput on

DECLARE

pnum number;

begin

pnum:='abc';

exception

when

value_error then dbms_output.put_line('value_erroe');

when

others then dbms_output.put_line('其他exception');

end;

标签：dbms,plsql,when,exception,put,oracle,output,line,异常

来源： https://www.cnblogs.com/wangchuanfu/p/10987928.html