SQL> CREATE SEQUENCE TEST_SEQ_A START WITH 1 MINVALUE 0 MAXVALUE 10 INCREMENT BY -1 NOCACHE ORDER CYCLE ; SQL> Insert into test(seq) values(TEST_SEQ_A.nextval); SQL> Select *from test;
输出:
1 0 1 0 1
日期:2020-06-02 22:16:58 来源:oir作者:oir
SQL> CREATE SEQUENCE TEST_SEQ_A START WITH 1 MINVALUE 0 MAXVALUE 10 INCREMENT BY -1 NOCACHE ORDER CYCLE ; SQL> Insert into test(seq) values(TEST_SEQ_A.nextval); SQL> Select *from test;
输出:
1 0 1 0 1