相关文章推荐
没读研的菠萝  ·  c++ - Is gettimeofday ...·  2 周前    · 
愉快的黄豆  ·  SQLServer中char、varchar ...·  4 天前    · 
飘逸的蘑菇  ·  浅谈SQL ...·  4 天前    · 
任性的菠菜  ·  excel里vba ...·  1 年前    · 
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