oracle触发器初步

实验接序列的那篇博客。

 

写一个触发器：

create or replace trigger trg_emp0_insert
before insert on emp0
for each row
  declare
  begin
    select seq_emp0_id.nextval into :new.id from dual;
    if :new.sal <0 then
      :new.sal :=0;
     elsif :new.sal > 10000 then
           :new.sal := 10000;
    end if;
   end; 

插入数据：

insert into emp0(name,sal) values('dhfdjghg',12340002);
insert into emp0(name,sal) values('dhfdjghg',-1);

查询：

select * from emp0;