关键词sequence
create table ss
(
noo int ,
ss_name varchar(10)
);
create sequence noo
start with 1000 --从100开始
increment by 1 --增量为1
maxvalue 9999 --最大9999
minvalue 1000 --最小1000
cycle;
insert into ss values('1000','乐山');
insert into ss values(noo.nextval,'成都');
select * from ss;
select noo currvar from ss;