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

Thread: How to chnage Datatype

  1. 08-24-2002, 04:03 AM #1
    sandycrab
    sandycrab is offline Member
    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!"
    Reply With Quote Reply With Quote
  2. 08-24-2002, 04:08 AM #2
    julian
    julian is offline Senior Advisor
    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
    Reply With Quote Reply With Quote
  3. 08-24-2002, 04:21 AM #3
    sandycrab
    sandycrab is offline Member
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Thanks Jilian, It's working...
    Cheers
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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