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;