举例说明:
/*修改原字段名*/
ALTER TABLE T_FIL_COLDINFO RENAME COLUMN coldtemperature TO coldtemperature1;
/*添加一个和原字段同名的字段*/
ALTER TABLE T_FIL_COLDINFO ADD coldtemperature VARCHAR2(20);
/*将原来的数据更新到新字段中*/
UPDATE T_FIL_COLDINFO SET coldtemperature = CAST(coldtemperature1 AS VARCHAR2(20));
/*删除原来的备份字段*/
ALTER TABLE T_FIL_COLDINFO DROP COLUMN coldtemperature1;