5.41.txt

delphi renyuanguanlixinxioxitong

CREATE OR REPLACE TRIGGER tr_emp_time
BEFORE INSERT OR UPDATE OR DELETE ON employee
BEGIN
  IF to_char(sysdate,'HH24') NOT BETWEEN '09' AND '17' THEN
    raise_application_error(-20101,'非工作时间');
  END IF;
END tr_emp_time;