--1,======加入id值的方法============================
--add colnmu
alter table UM_MTSMS_SUM
add P_ID number(10);
--update id
begin
update UM_MTSMS_SUM set p_id=UM_MTSMS_SUM_sseq.NEXTVAL where p_id is null;
end;
--praimry
alter table UM_MTSMS_SUM
add constraint PK_UMS_S primary key(P_ID);
转载于:https://www.cnblogs.com/java20131201/p/3476035.html