Oracle中序列的用法

创建sequence

create sequence hero_seq

increment by 1

start with 1

maxvalue 9999999

解释：hero_seq：一般是表明_seq

使用sequence

select hero_seq.nextval from dual

获取hero_seq的下一个值

select hero_seq.currval from dual

获取hero_seq的当前值

作为id插入到表中

insert into hero (id,name,hp,mp,damage,armor,speed) values(hero_seq.nextval,'炸弹人',450,200,45,3,300);