修改字段属性--oracle

/*修改原字段名name为name_tmp*/
alter table zn_lease rename column leasedescription to leasedescription_tmp;

/*增加一个和原字段名同名的字段name*/
alter table zn_lease add leasedescription varchar2(1000);

/*将原字段name_tmp数据更新到增加的字段name*/
update zn_lease set leasedescription=trim(leasedescription_tmp);

/*更新完，删除原字段name_tmp*/
alter table zn_lease drop column leasedescription_tmp;