1,修改序列:
ALTER SEQUENCE SEQ_STK_MSGRESUSTTMP
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999999999
cache 20
CYCLE NOORDER;
2,查找sequence的所有信息
select * from all_sequences a where a.sequence_name='SEQ_STK_CONTENT';
3,查找所有sequence
4,select * from all_sequences a where a.sequence_owner='STKRTTP';