ORACLE自增主键实现样例

CREATE TABLE userinfo (
 id number(10) NOT NULL ,
 username varchar(20) NOT NULL,
 password varchar(20) NOT NULL,
 email varchar(50) NOT NULL,
  PRIMARY KEY (id)
)
create or replace trigger tri_insert_userinfo
before insert on userinfo
for each row
begin
 select EMPID_sequence.nextval into :new.ID from dual;
end;

INSERT INTO userinfo VALUES ('1', 'aa', 'aa', 'aaa@sina.cn');

select * from userinfo