oracle sequence 清零(从记)

oracle sequence 清零(自记)删除:DROP SEQUENCE sequence_name新建:SequenceCREATE SEQUENCE seq_testINC

oracle sequence 清零(自记)

删除:DROP SEQUENCE sequence_name;新建:Sequence
CREATE SEQUENCE seq_test     INCREMENT BY 1 -- 每次加几个     START WITH 1    -- 从1开始计数     MAXVALUE   15   -- 设置最大值     NOCYCLE         -- 一直累加,不循环     CACHE 10    NOORDER    
启用和不启用选项,只要在单词前加no就行了