5.35.txt

delphi renyuanguanlixinxioxitong

CREATE OR REPLACE TRIGGER tr_sec_emp
BEFORE INSERT OR UPDATE OR DELETE ON employee
DECLARE
  -- 可以在这里声明私有变量
BEGIN
  IF to_char(SYSDATE,'DY','nls_date_language=AMERICAN') in ('SAT','SUN') THEN
     raise_application_error(-20001,'不能在休息日改变雇员信息');
  END IF;  
END tr_sec_emp;
/