-- Create sequence
create sequence SEQ_BASE_TABLESERIALNUMBER
minvalue 1
maxvalue 99999999
start with 30
increment by 1
cache 20
order;创建了这样的一个序列 但是为什么序列每次都增加2呢?
create sequence SEQ_BASE_TABLESERIALNUMBER
minvalue 1
maxvalue 99999999
start with 30
increment by 1
cache 20
order;创建了这样的一个序列 但是为什么序列每次都增加2呢?
2 minvalue 1
3 maxvalue 99999999
4 start with 30
5 increment by 1
6 cache 20
7 order;序列已创建。eygle@SZTYORA> select SEQ_BASE_TABLESERIALNUMBER.nextval from dual; NEXTVAL
----------
30eygle@SZTYORA> / NEXTVAL
----------
31eygle@SZTYORA> / NEXTVAL
----------
32eygle@SZTYORA> / NEXTVAL
----------
33
--会不会是两个人同时在用啊
scott@YPCOST> create sequence SEQ_BASE_TABLESERIALNUMBER
2 minvalue 1
3 maxvalue 99999999
4 start with 30
5 increment by 1
6 cache 20
7 order;Sequence created.scott@YPCOST> select seq_base_tableserialnumber.nextval from dual; NEXTVAL
----------
30scott@YPCOST> / NEXTVAL
----------
31scott@YPCOST> / NEXTVAL
----------
32
2 minvalue 1
3 maxvalue 99999999
4 start with 30
5 increment by 1
6 cache 20
7 order;序列已创建。eygle@SZTYORA>
eygle@SZTYORA> create table BASE_TABLESERIALNUMBER(
2 c1 number(18,0),
3 c2 varchar2(30),
4 c3 number(18,0),
5 c4 number(18,0),
6 c5 number(18,0),
7 c6 number(18,0),
8 c7 number(18,0),
9 c8 date,
10 c9 varchar2(30),
11 c10 varchar2(30),
12 c11 varchar2(30));表已创建。eygle@SZTYORA>
eygle@SZTYORA> insert into BASE_TABLESERIALNUMBER values(SEQ_BASE_TABLESERIALNUMBER.nextval,'3',1,1,6,1,'1',sysdate,'','','table')
2 ;已创建 1 行。eygle@SZTYORA> insert into BASE_TABLESERIALNUMBER values(SEQ_BASE_TABLESERIALNUMBER.nextval,'3',1,1,6,1,'1',sysdate,'','','table');已创建 1 行。eygle@SZTYORA> insert into BASE_TABLESERIALNUMBER values(SEQ_BASE_TABLESERIALNUMBER.nextval,'3',1,1,6,1,'1',sysdate,'','','table');已创建 1 行。eygle@SZTYORA> insert into BASE_TABLESERIALNUMBER values(SEQ_BASE_TABLESERIALNUMBER.nextval,'3',1,1,6,1,'1',sysdate,'','','table');已创建 1 行。eygle@SZTYORA> col c2 for a10
eygle@SZTYORA> col c9 for a10
eygle@SZTYORA> col c10 for a10
eygle@SZTYORA> col c11 for a10
eygle@SZTYORA> select * from BASE_TABLESERIALNUMBER; C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11
---- ---------- ---------- ---------- ---------- ---------- ---------- ------------------- ---------- ---------- ----------
30 3 1 1 6 1 1 2011-03-10 14:19:25 table
31 3 1 1 6 1 1 2011-03-10 14:19:28 table
32 3 1 1 6 1 1 2011-03-10 14:19:30 table
33 3 1 1 6 1 1 2011-03-10 14:19:32 table