ORACLE数据库把varchar2改为clob

1、添加字段
alter table TSMS_SENDSMS_LOG rename column CONT to CONT_BAK;

2、修改字段为clob
alter table TSMS_SENDSMS_LOG add CONT clob;

3、往字段里添加要修改的字段的数据
update TSMS_SENDSMS_LOG set CONT=CONT_BAK;
commit;

4、删除字段
alter table TSMS_SENDSMS_LOG drop column CONT_BAK;