数据库表字段中类型变更

alter table TB_SERVICECASE_WELFARE_SETTING add tmp_col varchar2(100);-- 添加临时列 
 
update TB_SERVICECASE_WELFARE_SETTING set tmp_col =EXPENSE_TIME ; --将目标字段中数据加入到临时列中 
 
update TB_SERVICECASE_WELFARE_SETTING set EXPENSE_TIME = null; --将目标字段数据清空 
 
alter table TB_SERVICECASE_WELFARE_SETTING modify ( "EXPENSE_TIME" NVARCHAR2(1000) ); --更改目标字段类型 
 
update TB_SERVICECASE_WELFARE_SETTING set EXPENSE_TIME = tmp_col; --将临时列数据加回到目标字段中 
 
alter table TB_SERVICECASE_WELFARE_SETTING drop column tmp_col; --清除临时列