varchar2转换clob问题

alter table table_name add column_new number;update table_name set  column_new=column_old;alter table table_name drop column column_old;alter table table_name rename column  column_new to column_old;