SQL 序列

--create sequence

create sequence tablename_seq

minvalue 1

maxvalue 99999

start with 8000

increment by 1

nocache;

--insert value with sequence

insert into tablename(id,name,comment) values (tablename_seq.NEXTVAL,'mingzi','beizhu');

--sequence两个方法

sequencename.nextval    下一个值

sequencename.currval     当前值