定义一个自动增长序列:
create sequence seq_custid start 1 incrememt by 1; 建表时:
create table cust
{ index integer not null,
...}
insert 时:
insert into table cust
values( seq_cust.nextval, ...)
create sequence seq_custid start 1 incrememt by 1; 建表时:
create table cust
{ index integer not null,
...}
insert 时:
insert into table cust
values( seq_cust.nextval, ...)
create sequence seq_id start 1 incrememt by 1; 建表时:
create table cust
{ index integer not null,
...}
insert 时:
insert into table cust
values( seq_id.nextval, ...)