5.41.txt

来自「delphi renyuanguanlixinxioxitong」· 文本 代码 · 共 9 行

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;