SQL Developer - Imported data truncated

Question

1.00/5 (1 vote)

See more:

I used Oracle SQL Developer to import data from an Excel file. Two of the fields were set as NUMBER(13,5). However, the results show that the numeric data in the 2 fields contain only 3 decimals, rather than 5. How can this problem be fixed? Thanks.

Posted 18-Aug-15 7:06am

s yu

Add a Solution

Comments

[no name] 18-Aug-15 13:20pm

Maybe only a Thing of trailing Zero question?
Some disussion here: http://www.blackwasp.co.uk/DecimalTrailingZeroes.aspx[^]

CHill60 19-Aug-15 7:36am

Are the numbers so large that it's had to round the decimals to include the number e.g. 1234567890.4567 becomes 1234567890.457?
Can you use NUMBER(*,5) instead?
It could be a case that you have something like 12345.12300123 in the excel file (ignoring any formatting in excel) which would come out as 12345.123.
Try posting some examples

Jörgen Andersson 21-Aug-15 3:01am

What data types are those fields in the Excel sheet?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)