Oracle varchar转clob

Oracle varchar转clob

//新建一个空字段name1，类型clob
alter table a8_header add name1 clob;
//将字段text13（varcahr2）的内容更新到name1
update a8_header set name1=text13;
commit;
//删除text13字段
alter table a8_header drop column text13;
//将name1字段名改为text13，偷梁换柱
alter table a8_header rename column name1 to text13;
commit;