orcle中触发器的使用

通过触发器和sequence实现id的自动增加

一，创建表格

create table user_test(
?id number not null,
?age number,
?name varchar2(30)
);

?

二，建立sequence

create sequence user_seq
minValue 100
maxValue 999999
start with 100
increment by 1
cache 20;

?

三，创建触发器

create or replace trigger user_trigger
before insert on user_test for each row
begin
?select user_seq.nextval into:new.id from dual;
end user_trigger;?

?? 注意：new.id的id为user_test表格中的列，dual;和user_trigger;中的;必须有

?

四，测试

insert into user_test(age,name) values(28,'Jack');
insert into user_test(age,name) values(27,'Tom');
insert into user_test(age,name) values(29,'Rose');

?

select * from user_teset

五，测试结束

drop sequence user_seq;

drop trigger user_trigger;

drop table user_test;