Easy way to change/update the oracle table column datatype without pain

ALTER TABLE es.response ADD approval_amount1 number(12,2); UPDATE es.response SET approval_amount1 = approval_amount; ALTER es.response MODIFY approval_amount (12,2); UPDATE es.response SET approval_amount=approval_amount1; ALTER TABLE es.response DROP COLUMN approval_amount1;