Oracle数据库之序列的创建、修改和删除操作

1、创建序列

1.1 创建序列：create sequence seqtest;

1.2 查询序列当前值：select seqtest.currval from dual;

1.3查询序列下一个值：select seqtest.nextval from dual;

1.4创建序列初始值为1，增副为1，循环|不循环：

create sequence testseq increment by 1 start with 1 maxvalue 99 cycle | nocycle;

2、修改序列

alter sequence testseq minvalue 0 | maxvalue 15;

3、删除序列

drop sequence testseq;