本文共 966 字，大约阅读时间需要 3 分钟。

Oracle SQL Sequence

Oracle SQL Sequence ??????????????????????????????????????????????????????

????????????????????

create sequence test_2;

???????????????????????????????????????????1????-5?

alter sequence test_2 increment by -5;

??????????????????

select test_2.nextval from dual;

????????????????????

alter sequence test_2 increment by 1;

?????????????????????????????ID???

SQL Sequence Increment Demonstration

???????????SQL Sequence ????????????????????????????????

1. ??????`create sequence test_2;`

2. ?????????`alter sequence test_2 increment by -5;`

3. ??????`select test_2.nextval from dual;`

4. ?????`alter sequence test_2 increment by 1;`

????????????????????????????????????

Sequence Increment Examples

??????????????

1. ??????`create sequence test_2;`

2. ???????`alter sequence test_2 increment by -5;`

3. ??????`select test_2.nextval from dual;`

4. ?????`alter sequence test_2 increment by 1;`

?????????????????????????????????????????????????????????