oracle 触发器

create trigger triggertest 
       after insert on empwc
       
       begin
          if to_char(sysdate,'hh24')<13 or to_char(sysdate,'hh24')>18
          then raise_application_error (-20000,'非工作时间不能增加员工信息');
            
          end if;
        end;

        

  
        create trigger triggertest1 
          after update or insert or delete on empwc 
          referencing new as nn old as oo
          for each row
           when(oo.sal>2000)
          begin
                if updating then dbms_output.put_line('Data has been updated');
                elsif inserting then  dbms_output.put_line('Data has been inserted');
                elsif deleting then dbms_output.put_line('Data has been deleted');
                
                end if;
                
                
                
          end;