select last_number from dba_sequences where sequence_name='MY_SEQ' AND SEQUENCE_OWNER = 'TS'
注意:不能修改序列对象的当前值。除非删除重新创建。
BEGIN
EXECUTE IMMEDIATE 'DROP SEQUENCE My_SEQ';
EXECUTE IMMEDIATE 'CREATE SEQUENCE My_SEQ INCREMENT BY 1 START WITH 300
NOMAXVALUE NOMINVALUE NOCYCLE NOCACHE ORDER';
COMMIT;
END;
写于 2010-10-15