SQL> create sequence seq_2;
ÐòÁÐÒÑ´´½¨¡£
SQL> set line 999;
SQL> select * from user_sequences;
SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
SEQ_1 1 1.0000E+27 1 N N 20 21
SEQ_2 1 1.0000E+27 1 N N 20 1
SQL> select seq_2.nextval from dual;
NEXTVAL
----------
1
SQL> select * from user_sequences;
SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
SEQ_1 1 1.0000E+27 1 N N 20 21
SEQ_2 1 1.0000E+27 1 N N 20 21
SQL> select seq_2.nextval from dual;
NEXTVAL
----------
2
SQL> select * from user_sequences;
SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER
------------------------------ ---------- ---------- ------------ - - ---------- -----------
SEQ_1 1 1.0000E+27 1 N N 20 21
SEQ_2 1 1.0000E+27 1 N N 20 21
SQL>