oracle 创建序列
2017-06-30 本文已影响0人
DamagedBoy
创建序列:
CREATE SEQUENCE sequence_name
[START WITH num]
[INCREMENT BY increment]
[MAXVALUE num|NOMAXVALUE]
[MINVALUE num|NOMINVALUE]
[CYCLE|NOCYCLE]
[CACHE num|NOCACHE]
更新序列中的值
UPDATE SYS.ALL_SEQUENCES SET LAST_NUMBER = 99999 WHERE LAST_NUMBER = 14544;