createorreplacetriggertri_checkbeforeinsertonempdeclarevdayvarchar2(30);beginselectto_char(sysdate,'day')intovdayfromdual;ifvday='thursday'thenraise_application_error(-20... create or replace trigger tri_check
before
insert
on emp
declare
vday varchar2(30);
begin
select to_char(sysdate,'day') into vday from dual;
if vday = 'thursday' then
raise_application_error(-20001,'周四老板,不允许插入数据');
--raise no_data_found;
end if;
end;
insert into XXXXX