// 判断ID字段是否存在
表名:HTS_USER_CUSTOM
新增主键:ID
序列:HTS_USER_CURSTOM_S_ID
// S1.添加新字段并设为空
alter table hts_user_custom add (ID number(10) null);
// S2.创建新序列
create sequence HTS_USER_CURSTOM_S_ID increment by 1 start with 1 nomaxvalue nocycle nocache;
// S3.更新ID
update hts_user_custom set ID = HTS_USER_CURSTOM_S_ID.nextval";
// S4.设置ID主键属性
alter table hts_user_custom add primary key (ID)";
// S5.设置主键不为空
alter table hts_user_custom modify ID number(10) not null";