测试序列

测试序列

创建测试序列： CREATE SEQUENCE my_sequence START WITH 2 INCREMENT BY 1 NOCACHE NOCYCLE;

1. 设置步长: ALTER SEQUENCE my_sequence INCREMENT BY 10;

2. 最大值限制: ALTER SEQUENCE my_sequence MAXVALUE 1000;

3. 移除序列的最大值限制: ALTER SEQUENCE my_sequence NOMAXVALUE;

4. 设置序列的最小值限制: ALTER SEQUENCE my_sequence MINVALUE 1;

5. 移除序列的最小值限制: ALTER SEQUENCE my_sequence NOMINVALUE;

6. 将序列的当前值重置为其起始值: ALTER SEQUENCE my_sequence RESTART;

7. 允许序列循环: ALTER SEQUENCE my_sequence CYCLE;

8. 不允许序列循环: ALTER SEQUENCE my_sequence NOCYCLE;

9. 设置序列的缓存大小: ALTER SEQUENCE my_sequence CACHE 20;

10. 禁用序列的缓存: ALTER SEQUENCE my_sequence NOCACHE;

11. 强制序列按照其生成的顺序分配值: ALTER SEQUENCE my_sequence ORDER;

12. 允许序列值的无序分配: ALTER SEQUENCE my_sequence NOORDER;

13.在缓存失效时保留序列值，避免回滚: ALTER SEQUENCE my_sequence KEEP;

1. 当缓存失效时，不保留序列值: ALTER SEQUENCE my_sequence NOKEEP;

2. 扩展序列的标度，允许更大的精度和小数位数: ALTER SEQUENCE my_sequence SCALE EXTEND;

3. 禁止扩展序列的标度: ALTER SEQUENCE my_sequence SCALE NOEXTEND;

4. 移除序列的标度限制: ALTER SEQUENCE my_sequence NOSCALE;

*18. 扩展序列的分片属性: --ALTER SEQUENCE my_sequence SHARD EXTEND; *19. 禁止扩展序列的分片属性: --ALTER SEQUENCE my_sequence SHARD NOEXTEND; ***20. 移除序列的分片属性: --ALTER SEQUENCE my_sequence NOSHARD;

1. 序列的生命周期限定在会话级别: ALTER SEQUENCE my_sequence SESSION;

2. 序列的生命周期限定在全局级别: ALTER SEQUENCE my_sequence GLOBAL;