修改oracle数据库字段类型，有值的情况。

/*修改原字段名name为name_tmp*/
alter table zfs_room_allot rename column roomCode to roomCode_tmp;
alter table zfs_room_allot rename column roomName to roomName_tmp;

/*增加一个和原字段名同名的字段name*/
alter table zfs_room_allot add roomCode CLOB;
alter table zfs_room_allot add roomName CLOB;

/*将原字段name_tmp数据更新到增加的字段name*/
update zfs_room_allot set roomCode=trim(roomCode_tmp);
update zfs_room_allot set roomName=trim(roomName_tmp);

/*更新完，删除原字段name_tmp*/
alter table zfs_room_allot drop column roomCode_tmp;
alter table zfs_room_allot drop column roomName_tmp;