jiuzhoutong/sql/ALTERCT_INT_LOGINFO.sql

-- 添加新列
ALTER TABLE CT_INT_LOGINFO
ADD (CFINTERFACEADDRESS_TEMP NCLOB);

-- 复制数据
UPDATE CT_INT_LOGINFO
SET CFINTERFACEADDRESS_TEMP = CFINTERFACEADDRESS;

-- 删除原列
ALTER TABLE CT_INT_LOGINFO
DROP COLUMN CFINTERFACEADDRESS;

-- 重命名新列
ALTER TABLE CT_INT_LOGINFO
RENAME COLUMN CFINTERFACEADDRESS_TEMP TO CFINTERFACEADDRESS;