Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Storing trailing zeros in mantissa

Re: Storing trailing zeros in mantissa

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 7 Aug 2003 21:29:52 +1000
Message-ID: <3f3239c9$4$10356$afc38c87@news.optusnet.com.au>


"John Russell" <netnews6_at_johnrussell.mailshell.com> wrote in message news:lfq3jvoludjfv4bvkoa3po9oq7j07kicn9_at_4ax.com...

>

> How about declaring the column to have a lot more precision? I think
> the original post mentioned the column was NUMBER(18,2), which might
> be fine for adding and subtracting currency, but I wouldn't use it for
> recording the paths of subatomic particles in a supercollider.

Heh! If you use Pi=3.141592653589,
that will give you enough precision to calculate the perimeter of the Moon orbit with less than a millimeter error. Just in case you need too much precision...
<g,d&r>

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Aug 07 2003 - 06:29:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US