/*Oracle创建序列*/

关键词sequence

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