Oracle数据库：查询序列、删除序列

一、查询序列：

        1、查询当前用户下的序列：select * from user_sequences;

举例说明：

SQL> CREATE SEQUENCE seq_WGB_Test2
  2  INCREMENT BY 1
  3  START WITH 1000;

序列已创建。

SQL> select * from user_sequences;

SEQUENCE_NAME     MIN_VALUE  MAX_VALUE   INCREMENT_BY  C  O  CACHE_SIZE  LAST_NUMBER
---------------   ---------  ----------  ------------  -  -  ----------  -----------
SEQ_WGB_TEST2     1          1.0000E+28  1             N  N  20          1000

        2、查询所有的序列：select * from all_sequences;

select * from all_sequences;

SQL> select * from all_sequences;

SEQUENCE_OWNER                 SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ------------------------------ ---------- ---------- ------------ - - ---------- -----------
SYS                            SCHEDULER$_JOBSUFFIX_S                  1 1.0000E+28            1 N N         20
        171
SYS                            DM$EXPIMP_ID_SEQ                        1 1.0000E+28            1 N N         20
          1
SYS                            HS_BULK_SEQ                             1 1.0000E+28            1 N N          0
          1
XDB                            XDB$NAMESUFF_SEQ                        1      99999            1 Y N         20
        568
MDSYS                          SDO_NDM_ID_SEQ                          1 1.0000E+28            1 N N          0
          1
MDSYS                          SAMPLE_SEQ                              1 1.0000E+28            1 N N         20
          1
MDSYS                          SDO_WS_CONFERENCE_IDS                   1 1.0000E+28            1 N N          0
          1
MDSYS                          TMP_COORD_OPS                     1000000    2000000            1 Y N          0     1000000
OLAPSYS                        DBMS_MVSEQ                           1000       9999            1 Y N         20        1000
MDSYS                          SDO_GEOR_SEQ                            1 1.0000E+28            1 N N         10
          1
MDSYS                          SDO_IDX_TAB_SEQUENCE                    1 1.0000E+27            1 Y N         20
          1
APEX_030200                    WWV_SEQ                                 1 1.0000E+28            1 N N         20       10441
APEX_030200                    WWV_FLOW_SESSION_SEQ                    1 1.0000E+28            1 N N         20
          1
BS                             SEQ_WGB_TEST2                           1 1.0000E+28            1 N N         20        1000

已选择14行。

二、删除序列：drop sequence 序列名;

SQL> drop sequence SEQ_WGB_TEST2;

序列已删除。