1. 

   Shanmugapriya Active Member

   Messages:

   55

   Likes Received:

   0

   Trophy Points:

   130

   Location:

   Bangalore

   Hi,
   I have an excel which is in csv format. I am trying to import this data to the table using sql developer.
   
   But I get the same number through out the full column as 100005000000000.
   
   It is the field with datatpe NUMBER(25,0). Actual number is different.
   
   Kindly suggest

    

   Shanmugapriya, Dec 13, 2016

   #1
2. 

   zargon Community Moderator Forum Guru

   Messages:

   2,645

   Likes Received:

   372

   Trophy Points:

   1,430

   Location:

   Aurora, CO

   You need to post the data, the version of SQL Developer and the version of the database. To make a suggestion have you exported the data as a CSV from Excel and tried SQL Loader to process the data? You would probably see better results if you did.

    

   zargon, Dec 13, 2016

   #2

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in