We have a need to
change the datatype of several columns in a table from number to
varchar2. Most of the rows have data in these columns hence a direct 'alter
table ...' will not work.
We plan to create a
temp table, move the data from these colums to that table, modify the
column datatype from number to varchar2 and then update the colums with the data
that was moved to the temp table.
Any
suggestions/comments or a better way to do this ? Oh, and we are on
8.1.7.1
thanx
deepak