关于oracle 中字段的递增问题
我要建立一个表,create table SaleSlist(AssessID number(8,0) identity(1,1) not
null,AssessTime varchar(6) not null,SalesManID varchar(8) not null,
SalesManTotal number(18,0) default 0 not null,constraint fk_s
foreign(SalesManID) references SalesMan(SalesManID));其中要实现AssessID
字段的递增,请问该怎么办啊,写出具体的解决办法啊
==========================================================================
建议给SaleSlist表创建一个序列，就会实现AssessID 自增
-- Create sequence
create sequence SQE_SaleSlist
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20
order;
