How to chnage Datatype
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to chnage Datatype

  1. #1
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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!"

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    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
  •  


Click Here to Expand Forum to Full Width