Re: Strange precision related math errors...

From: Alexander Z <ziryanov_at_lycos.com>
Date: Thu, 27 Sep 2001 18:52:14 GMT
Message-ID: <yzKs7.20712$w7.4038495@news02.optonline.net>

before SELECT statment issue:
COLUMN column_name FORMAT 99.99EEEE;

for more detailed information look SQL*Plus Quick Reference / Formatting Query Results

Alexander.

"Andreas Koch" <mail_at_kochandreas.com> wrote in message news:9ovpmi$1j7$03$1_at_news.t-online.com...
>
>
> 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
>
Received on Thu Sep 27 2001 - 13:52:14 CDT