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;