oracle 创建自增字段

1 建立序列

create sequence seq
increment by 1
start with 1
maxvalue 999;

2 建立触发器

create or replace trigger trg before
insert on userInfor
for each row begin
select seq.nextval
into :new.name
from dual;
end trg;

3 向数据库中插入数据

insert into table userInfor('aa','ff');

4 查询数据库

select * from userInfor;

显示的结果是  1        ff