开始
set serveroutput on; DECLARE e_no_rows EXCEPTION; e_integrity EXCEPTION; BEGIN BEGIN RAISE e_no_rows; END; EXCEPTION WHEN e_no_rows THEN DBMS_OUTPUT.PUT_LINE('no rows exception'); END;
运行结果:
anonymous block completed
no rows exception
结束
本文转自健哥的数据花园博客园博客,原文链接:http://www.cnblogs.com/gaojian/archive/2012/11/23/2784361.html,如需转载请自行联系原作者