Re: Strange precision related math errors...

Thomas Kyte wrote:

>
> A B C A/B (A/B)/C 1-((A/B)/C)
> ---------- ---------- ---------- ---------- ---------- -----------
> 19558001 10000000 1.9558 1.9558001 1.00000005 -5.113E-08
>
>
> So 1-((a/b)/c) is not -5.1129 -- you seem to have chopped off the E-08 from
> that.
>
> Lets see a cut and past from sqlplus like the above -- you are missing something
> -- what is the client program here?

Well, the client programm is SqlPlus, and the problem is sort of solved...

It is a pure display problem - SQL*Plus doesn't show the me E-08 part.

I did an error in the <1 check that caused my to think its no display problem.

So, as it is a display problem, how do i set up SqlPlus to display the E ?

-- 
                                       Andreas
Who doesn't live can never die