oracle实现自增ID 创建seq和触发器

- 创建seq

 

CREATE SEQUENCE user$seq
  INCREMENT BY 1  
  MINVALUE 1  
  MAXVALUE 9223372036854775807  
  START WITH 1  
  CACHE 5;  




 - 设置主键


  ALTER TABLE user
    ADD PRIMARY KEY (id);

 

 - 创建触发器

 

CREATE TRIGGER user$trig
   BEFORE INSERT ON  user
   FOR EACH ROW
   WHEN (New.id is null) 
begin
   select user$seq.nextval into :New.id from dual;
end;