my_exception2.sql

来自「pl/sql的综合运用上例用到的oracle里关于游标的几个内置函数:％isop」· SQL 代码 · 共 20 行

SET serveroutput ON;

DECLARE
	   e_too_many EXCEPTION;
	   e_too_low EXCEPTION;
	   v_count NUMBER(10);
BEGIN 
	SELECT COUNT(empno) INTO v_count FROM emp 
	WHERE sal > (SELECT AVG(sal) FROM emp);
	IF v_count > 5 THEN RAISE e_too_many; END IF;
	IF v_count < 5 THEN RAISE e_too_low; END IF;
EXCEPTION
		 WHEN e_too_many THEN
		 	  dbms_output.put_line('高工资人数太多');
		 WHEN e_too_low THEN
		 	  dbms_output.put_line('低工资人数太多');
		 WHEN OTHERS THEN
		 	  dbms_output.put_line('其它异常');
END;