[Oracle] 查询修改序列对象的当前值

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