1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Importing data error

Discussion in 'SQL PL/SQL' started by Shanmugapriya, Dec 13, 2016.

  1. Shanmugapriya

    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
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,599
    Likes Received:
    363
    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.