Column datatype conversion from number to varchar2
We have a column that needs to be converted from number to varchar2. The table has millions of rows. What would be the best way to achieve the conversion?
One option is to
1) create a new column of type varchar2
2) update the new column with the old column
3) drop the old column
4) rename the new column back to the original name
Is there a better way? We are running on Oracle 11.2.0.3
Thanks
One option is to
1) create a new column of type varchar2
2) update the new column with the old column
3) drop the old column
4) rename the new column back to the original name
Is there a better way? We are running on Oracle 11.2.0.3
Thanks
0