Oracle-Modify Field Type

Oracle-Example of modifying the field type: l_amount_temp is a temporary field, and L_AMOUNT is a field to be modified. SQL code alter table alter add l_amount_temp int; www.2cto.com alter table modify L_AMOUNT NULL; update into set l_amount_temp = L_AMOUNT, L_AMOUNT = NULL; commit; alter table modify L_AMOUNT float (24 ); update into 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; author czpae86