How to prevent auto rounding in oracle ?

Question

0.00/5 (No votes)

See more:

Hello Everyone,

I need one solution to prevent automatic rounding of number in oracle. Here I am explaining what I want.Please go through this flow.

SQL> create table dm_demo(no number(23,9));

Table created

SQL> insert into dm_demo values (9999999.999999999);

1 row inserted

SQL> select * from dm_demo;

NO
-------------------------
10000000.000000000

Now if i use to_char() then it will show me the correct figure. But the thing is I don't want to use to_char().

SQL> select to_char(no) from dm_demo;

TO_CHAR(NO)
----------------------------------------
9999999.999999999

Please help me out to accomplish this task and Please let me know if you have some other solutions. Thank You.

Posted 12-Mar-15 3:13am

Member 10500506

Updated 12-Mar-15 18:49pm

v2

Add a Solution

Comments

Jörgen Andersson 13-Mar-15 7:10am

It's not Oracle, the program you're using for presenting the results is using Double internally.
Tell us how you're using the data that gets rounded.

Member 10500506 14-Mar-15 3:32am

I am not using any program. I am using Oracle's SQL Plus to Execute this Query.

Jörgen Andersson 14-Mar-15 7:18am

Well that's also a program, but Oracle, so there is a solution.

2 solutions

Add a Solution

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)

Jörgen Andersson · Answer 1 · 2015-03-14T01:22:00

Solution 1

As Tom Kyte says[^]: "

SQLPlus has a default number format is uses to display data on the screen "nicely".  You need to
either

o set the numformat to something you like
o use a TO_CHAR on the number with a format that applies in your case.

Info on how to set Numformat here[^].

Posted 14-Mar-15 1:22am

Jörgen Andersson

Smart003 · Answer 2 · 2015-03-17T09:54:00

Solution 2

in oracle to display a numbers after the decimal point we use the concept of precision in the number datatype.check about it

Posted 17-Mar-15 9:54am

Smart003