Oracle 使用SQL语句对序列的操作

创建序列

CREATE SEQUENCE test_seq 
    MINVALUE 1 
    MAXVALUE 9999999999 
    START WITH 100000 
    INCREMENT BY 1 
    CACHE 20

查询所有序列

select * from user_sequences;

查询特定序列

select * from user_sequences where sequence_name like '%T_SELL_BRAND%';
select * from user_sequences where sequence_name = 'SEQ_T_SELL_BRAND';