This discussion is archived
2 Replies Latest reply: Jan 23, 2013 11:15 PM by HamidHelal RSS

Data Importing

983519 Newbie
Currently Being Moderated
Hi,
When I import the data from .xls file to oracle DB i am facing the following problem.
In .xls file the values in a column are 10.67,19.96,15.36......
at the time of importing it from oracle sql developer i am getting 11,20,15....in the DB
Could any one suggest me what i can do to get the exact data
  • 1. Re: Data Importing
    Marwim Expert
    Currently Being Moderated
    Hello,

    this is the forum for Oracle Forms. Your question should be asked in {forum:id=260}.

    Before you post there you should look at the column, maybe it is defined as NUMBER(n,0) or INTEGER. Then the values will be rounded automatically.

    To help you you should include some information into your new post:
    * db version
    * SQL Developer version
    * structure of your Excel file (columns, a real binary XLS format or a CSV named .xls)
    * definition of the target table

    Regards
    Marcus
  • 2. Re: Data Importing
    HamidHelal Guru
    Currently Being Moderated
    Hi Sri,
    When I import the data from .xls file to oracle DB i am facing the following problem.
    In .xls file the values in a column are 10.67,19.96,15.36......
    at the time of importing it from oracle sql developer i am getting 11,20,15....in the DB
    Could any one suggest me what i can do to get the exact data
    You are suggested to post @ SQL Developer (Not for general SQL/PLSQL questions) so you post in wrong place. How ever,

    Welcome to the Oracle Forums. Please take a few minutes to review the following:

    <ul>
    <li>Oracle Forums FAQ
    <li>Before posting on this forum please read
    <li>10 Commandments for the OTN Forums Member
    <li>How to ask questions the smart way
    </ul>

    Following these simple guidelines will ensure you have a positive experience in any forum; not just this one!

    Suggestion

    Check your database table column property for fraction input.
    If your column property like
    DEPT_ID     NUMBER(10,0) -- don't support decimal.
    and
    DEPT_ID     NUMBER(10,6) -- support decimal.
    Hope this helps


    Hamid


    If someone's response is helpful or correct, please mark it accordingly.*

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points