17,086
社区成员
发帖
与我相关
我的任务
分享
SQL> create sequence s_aspen start with 1 increment by 1 nocache;
Sequence created.
SQL> SQL> create table t_aspen (t_int int);
Table created.
SQL> insert into t_aspen values(s_aspen.nextval);
1 row created.
SQL> select * from t_aspen;
T_INT
----------
1
SQL> select s_aspen.nextval from dual;
NEXTVAL
----------
2
SQL> SQL> insert into t_aspen values(s_aspen.nextval);
1 row created.
SQL> SQL> commit;
Commit complete.
SQL> select * from t_aspen;
T_INT
----------
1
3
SQL> SQL> insert into t_aspen values(s_aspen.nextval);
1 row created.
SQL> rollback;
Rollback complete.
SQL> insert into t_aspen values(s_aspen.nextval);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t_aspen;
T_INT
----------
1
3
5
SQL>