-
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
"Greatest Rewards come only with Greatest Commitments!"
-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Thanks Jilian, It's working...
Cheers
Sandy
"Greatest Rewards come only with Greatest Commitments!"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|