oracle批改字段类型

oracle修改字段类型

例子:l_amount_temp是临时字段, L_AMOUNT是要修改的字段.

?

?

alter table LAW_LITIGATION_CASE add  l_amount_temp int;　　　　alter table LAW_LITIGATION_CASE modify L_AMOUNT NULL;　　update LAW_LITIGATION_CASE set  l_amount_temp=L_AMOUNT,L_AMOUNT=NULL;　　commit;　　alter table LAW_LITIGATION_CASE modify L_AMOUNT float(24);　　update LAW_LITIGATION_CASE set L_AMOUNT= l_amount_temp, l_amount_temp=NULL;　　commit;　　alter table LAW_LITIGATION_CASE drop column  l_amount_temp;　　alter table LAW_LITIGATION_CASE modify L_AMOUNT NOT NULL;