Oracle转换修改字段类型

 

把VARCHAR2(4000)改为clob;

--增加新字段rdaccnames
alter table OA_INFOMATION_EXCHANGE add rdaccnames clob;
--将需要改成accnames字段的项内容copy到rdaccnames字段中
update OA_INFOMATION_EXCHANGE set rdaccnames=accnames where accnames is not null;
--删除原有字段accnames
alter table OA_INFOMATION_EXCHANGE drop column accnames;
--将rdaccnames 字段名改成accnames字段名
alter table OA_INFOMATION_EXCHANGE rename column rdaccnames to accnames;