Oracle varchar转clob

//新建一个空字段name1，类型clobalter table a8_header add name1 clob;//将字段text13（varcahr2）的内容更新到name1update 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;