Oracle数据库:查询序列、删除序列方式

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

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行。

sql> drop sequence seq_wgb_test2;