SQL> create table test (
2 id number(8) primary key,
3 name varchar2(20) not null);表已创建。SQL> create sequence test_seq
2 start with 1
3 increment by 1
4 nocache;序列已创建。SQL> insert into test (id,name) values (test_seq.nextval,'aaa');已创建 1 行。SQL> select * from test; ID NAME
---------- --------------------
2 aaa各位大虾,为什么我的序列老是从2开始?
2 id number(8) primary key,
3 name varchar2(20) not null);表已创建。SQL> create sequence test_seq
2 start with 1
3 increment by 1
4 nocache;序列已创建。SQL> insert into test (id,name) values (test_seq.nextval,'aaa');已创建 1 行。SQL> select * from test; ID NAME
---------- --------------------
2 aaa各位大虾,为什么我的序列老是从2开始?
10g上面就是好好的,从1开始的。
create sequence test_seq
2 start with 0
3 increment by 1
4 nocache;