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: NUMBER Vs NUMBER(38)

Re: NUMBER Vs NUMBER(38)

From: <markp7832_at_my-deja.com>
Date: Fri, 27 Aug 1999 13:50:21 GMT
Message-ID: <7q652p$icc$1@nnrp1.deja.com>


In article <Qn5NFAAapXx3Ew9W_at_rwx777.demon.co.uk>,   Steve Haynes <steve_at_nospamrwx777.demon.co.uk> wrote:
> In article <37cc5033.33238454_at_newshost.us.oracle.com>, Thomas Kyte
> <tkyte_at_us.oracle.com> writes
> >but the of decimal places is very different.... they have the same
precision
> >(number of digits) but a number(38) is the same as number(38,0) so
the scales
> >are different (scale being the number of digits to the right of the
decimal)
> Am I the only one who thinks that the terms precision and scale
> would be better swapped?
> Scale to me is the number to the left of the decimal
> and precision is the number of decimal places.
> It just sits better with me.
> Steve
> --
> Please remove nospam from my address to Reply.
>

It seems to me that Oracle uses the terms correctly. At lease they agree with my High Scool Chemistry and college Finance classes. --
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 08:50:21 CDT

Original text of this message

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