1、创建序列
CREATE SEQUENCE Z_SERVICE_LOG_SEQ INCREMENT BY 1 MAXVALUE 999999999 MINVALUE 1 CYCLE;
2、获取序列
SELECT Z_SERVICE_LOG_SEQ.NEXTVAL FROM DUMMY;
3、删除序列
DROP SEQUENCE Z_SERVICE_LOG_SEQ;
4、获取当前序列
SELECT Z_SERVICE_LOG_SEQ.currval AS MAX_TASK_NO_SEQ FROM DUMMY
5、序列还原到1
ALTER SEQUENCE Z_SERVICE_LOG_SEQ INCREMENT BY 1;