一、查询序列
1、查询当前用户下的序列
1 | select * from user_sequences; |
举例说明：
1 2 3 | SQL> CREATE SEQUENCE seq_WGB_Test2 2 INCREMENT BY 1 3 START WITH 1000; |
序列已创建。
1 2 3 4 5 | 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、查询所有的序列
1 | select * from all_sequences; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 | 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 171SYS DM$EXPIMP_ID_SEQ 1 1.0000E+28 1 N N 20 1SYS HS_BULK_SEQ 1 1.0000E+28 1 N N 0 1XDB XDB$NAMESUFF_SEQ 1 99999 1 Y N 20 568MDSYS SDO_NDM_ID_SEQ 1 1.0000E+28 1 N N 0 1MDSYS SAMPLE_SEQ 1 1.0000E+28 1 N N 20 1MDSYS SDO_WS_CONFERENCE_IDS 1 1.0000E+28 1 N N 0 1MDSYS TMP_COORD_OPS 1000000 2000000 1 Y N 0 1000000OLAPSYS DBMS_MVSEQ 1000 9999 1 Y N 20 1000MDSYS SDO_GEOR_SEQ 1 1.0000E+28 1 N N 10 1MDSYS SDO_IDX_TAB_SEQUENCE 1 1.0000E+27 1 Y N 20 1APEX_030200 WWV_SEQ 1 1.0000E+28 1 N N 20 10441APEX_030200 WWV_FLOW_SESSION_SEQ 1 1.0000E+28 1 N N 20 1BS SEQ_WGB_TEST2 1 1.0000E+28 1 N N 20 1000已选择14行。 |
二、删除序列：drop sequence 序列名;
1 | SQL> drop sequence SEQ_WGB_TEST2; |
序列已删除。
总结
以上为个人经验，希望能给大家一个参考，也希望大家多多支持IT俱乐部。
