create or replace trigger securityemp
before insert
on emp
declare
begin
if to_char(sysdate,'day') in ('星期六','星期日') or
to_number(to_char(sysdate.'hh24')) not between 9 and 18 then
--禁止insert員工
raise_application_error(-20001,'禁止在非工作時間插入員工');
end if;
end;
/
