suibi

create or replace trigger forbid_emp_x_trigger2
before insert or delete or update
on emp_x
declare
 v_currentweak varchar(20);
v_currenthour varchar(20);
 begin
 select to_char(sysdate,'day'),to_char(sysdate,'hh24') into v_currentweak,v_currenthour
  from dual;
  if trim(v_currentweak)='monday' or trim(v_currentweak)='saturday' or trim(v_currentweak)='sunday'
  then
  raise_application_error(-20008,'A');
  elsif trim(v_currenthour)<9 or trim(v_currenthour)>18 then
 raise_application_error(-20009,'B');
  end if;
  end;
  /
create or replace trigger forbid_emp_trigger3
before update of sal,comm
on emp
declare
currenthour varchar(20);
begin
select to_char(sysdate,'hh24')into currenthour from dual;
if trim(currenthour)>'12'then
raise_application_error(-20009,'meitian12dianyihoubuyunxugengxinguyuangongzi、yongjin');
end if;
end;


create or replace trigger forbid_emp_x_trigger4
before insert
on emp_x
for each row
declare
v_jobcount number;
begin
select count(empno)into v_jobcount from emp where:new.job in(
select distinct job from emp);
if v_jobcount = 0 then --没有此职位信息
raise_application_error(-20008,'zengjiaguyuandezhiweixinximingchengcuowu!');
else
if:new.sal>5000 then
raise_application_error(-20008,'zengjiaguyuandegongzibudechaoguo5000!');
end if;
end if;
end;
/


create or replace trigger emp_update_trigger5
before update of sal
on emp_x
for each row
begin
if abs((:new.sal-:old.sal)/:old.sal)>0.1 then
raise_application_error(-20008,'guyuanxiugaifudutaida!');
end if;
end;