oracle中的触发器实现自增效果

1. 建立表
   create table user(
       id number(6) not null,
       name varchar2(30) not null primary key
   );

2. 建立序列SEQUENCE
   create sequence user_seq;

3. 创建自增的触发器
   create or replace trigger user_trigger
   before insert on user for each row
   begin
         select user_seq.nextval into:new.id from sys.dual;
   end;