PLSQL修改字段为不同类型

--将数字类型转换为字符串

--原字段更改名字

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;