use sequence
like this:
create sequence seq_id incremet by 1 start with 1;create table t1(a int);
insert into t1 values (seq_id.nextval);
insert into t1 values (seq_id.currval);
like this:
create sequence seq_id incremet by 1 start with 1;create table t1(a int);
insert into t1 values (seq_id.nextval);
insert into t1 values (seq_id.currval);
create sequence seq_id increment by 1 start with 1 maxvalue 999999999;插入语句这样写
insert into tbname values(seq_id.nextval,...);
create sequence table_sequence
increment by 1
start with 1
nomaxvalue
nocycle
.......其中start with指定序列的起始值,increment by指定增值,nomaxvalue为没有上限.插入记录
插入语句这样写
insert into table_name values(table_sequence.nextval,...);