修改字段类型脚本 oracel

SELECT MONTHLY_WAGES from CLS_CUST_INFO

ALTER TABLE CLS_CUST_INFO   ADD( xinzengjia  varchar2(20));

UPDATE CLS_CUST_INFO SET xinzengjia = MONTHLY_WAGES;

UPDATE CLS_CUST_INFO SET MONTHLY_WAGES = null;

ALTER TABLE CLS_CUST_INFO modify MONTHLY_WAGES VARCHAR2(10);

UPDATE CLS_CUST_INFO SET MONTHLY_WAGES = xinzengjia;

ALTER TABLE CLS_CUST_INFO DROP COLUMN xinzengjia;