无法触发触发器
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
举报