2 Replies Latest reply: Jan 24, 2013 1:15 AM by HamidHelal RSS

    Data Importing

    983519
      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
          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
            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 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.*