增加属性应该是这样写的吧
ALTER TABLE cust_id ADD cust_id_seq number(9) identity(1,1)
如果你要搞sequence
CREATE SEQUENCE cust_id_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 999999999
NOCYCLE;
增加的时候用cust_id_seq.nextval
你看看解决了不
alter table cust_info add sequence int
insert into cust_info (sequence)
select row_number() over(order by cust_id) as cust_id_seq from cust_info
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024