I have a table in my Oracle8i database with a column with Varchar2 datatype. I want to change the same to Number. Could anyone plz tell me how to do the same??
Thanks in advance...
Sandy
Printable View
I have a table in my Oracle8i database with a column with Varchar2 datatype. I want to change the same to Number. Could anyone plz tell me how to do the same??
Thanks in advance...
Sandy
There are several ways. If the table is not huge, I would add a new column (number), insert all from the varchar2 column into the number column (but beware 'ABC' and alike cannot be transfered to the number column, only '975' and alike can be). Then drop the varchar2 column.
Thanks Jilian, It's working...
Cheers
Sandy