创建序列:
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;
网友评论