ORACLE序列查询、新增

1、查询序列

 SELECT sequence_name 
     FROM user_sequences 
     WHERE sequence_name = '序列名';

2、新增序列

CREATE SEQUENCE SEQ_BATCH_ID
     START WITH 1
     INCREMENT BY 1
     NOMAXVALUE
     NOCYCLE
     CACHE 10