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: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: Thu, 26 Aug 1999 18:33:14 +0100
Message-ID: <Qn5NFAAapXx3Ew9W@rwx777.demon.co.uk>


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. Received on Thu Aug 26 1999 - 12:33:14 CDT

Original text of this message

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