I have a number column in a table, It has more than 20 million records in it.
But now the users want some new records in this format(0123, 01455, ..).
I cannot change the datatype to varchar2, as the table is not empty.
Adding a new column , updating the new column with old, dropping the old and renaming the new is not possible as in many places inside the DB, there are inserts without column list.
Also adding a new column, updating the new from old, nullify the old and changing the datatype is not possible, because so many million records need to be updated 3 times. DBA is not accepting this solution.
Is there any other way?