oracle plsql 异常
发布时间:2021-01-24 04:55 所属栏目:[站长百科] 来源:网络整理
导读:set serveroutput onDECLAREpename emp.ename%type;beginselect ename into pename from emp where ename=‘1213‘;exceptionwhenno_data_found then dbms_output.put_line(‘没有该数据‘);whenothers 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 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; 【免责声明】本站内容转载自互联网,其相关言论仅代表作者个人观点绝非权威,不代表本站立场。如您发现内容存在版权问题,请提交相关链接至邮箱:bqsm@foxmail.com,我们将及时予以处理。 |
相关内容
推荐文章
热点阅读