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
     
    Shanmugapriya, Dec 13, 2016
    #1
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,660
    Likes Received:
    375
    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