原来表中午主键新增一个主键
– 增加一个ID字段
– Add/modify columns
alter table tablename add id number;
–创建自增序列
– Create sequence
create SEQUENCE seq_tablename
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
–更新id的值
UPDATE tablename A SET A.id=seq_tablename .nextval WHERE a.id IS NULL;
–添加主键
alter table tablename
add constraint SYS_tablename primary key (ID);
–查看修改后的结果
SELECT * FROM tablename ;
由于主键不能为空 所以只能迂回