限制在工作日9点到18点之间才可以操作数据
CREATE OR REPLACE TRIGGER TRI_SJXZ
BEFORE INSERT OR DELETE OR UPDATE ON STU
BEGIN
IF(TO_CHAR(SYSDATE,'DAY') IN ('星期六','星期日') OR (TO_CHAR(SYSDATE,'HH24:MI') NOT BETWEEN '09:00' AND '18:00')) THEN
RAISE_APPLICATION_ERROR(-20001,'不是上班时间,不能修改STU表');
END IF;
END;