ORACLE复习要素.ppt

CREATE OR REPLACE PACKAGE PKG_DEPTNO AS V_DEPTNO EMP.DEPTNO%TYPE; V_SAL EMP.SAL%TYPE; END; CREATE OR REPLACE TRIGGER trg_updateemp BEFORE UPDATE ON EMP FOR EACH ROW BEGIN PKG_DEPTNO.V_SAL:=:NEW.SAL; PKG_DEPTNO.V_DEPTNO:=:NEW.DEPTNO; END; CREATE OR REPLACE TRIGGER trg_statement AFTER UPDATE ON EMP DECLARE v_highsal emp.sal%type; v_lowsal emp.sal%type; BEGIN SELECT MAX(SAL),MIN(SAL) INTO v_highsal,v_lowsal FROM EMP WHERE DEPTNO= PKG_DEPTNO.V_DEPTNO; IF PKG_DEPTNO.V_SALv_highsal or pkg_deptno.v_salv_lowsal THEN RAISE_APPLICATION_ERROR(-20001,THE SAL IS BEYOND!);