无法触发触发器
CREATE or REPLACE TRIGGER securityemp BEFORE INSERT ON emp declare begin if to_char(sysdate,'day') in ('saturday','sunday','friday') then raise_application_error(-20001,'禁止在非工作时间插入新员工'); end if; end; /
CREATE or REPLACE TRIGGER securityemp BEFORE INSERT ON emp declare begin if to_char(sysdate,'day') in ('saturday','sunday','friday') then raise_application_error(-20001,'禁止在非工作时间插入新员工'); end if; end; /
2018-12-28
举报