--将数字类型转换为字符串
--原字段更改名字
alter table CUST_GD_DATA_DELETE rename column MAIN_SYSTEM_STAFFID to MAIN_SYSTEM_STAFFID2;
--增加字段
ALTER TABLE CUST_GD_DATA_DELETE ADD MAIN_SYSTEM_STAFFID VARCHAR2(500);
--备注
comment on column CUST_GD_DATA_DELETE.MAIN_SYSTEM_STAFFID is '主责系统负责人ID';
--数据转移
UPDATE CUST_GD_DATA_DELETE SET MAIN_SYSTEM_STAFFID = MAIN_SYSTEM_STAFFID2;
--删除字段
ALTER TABLE CUST_GD_DATA_DELETE DROP COLUMN MAIN_SYSTEM_STAFFID2;