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

Home -> Community -> Usenet -> c.d.o.misc -> Re: what datatype to use question

Re: what datatype to use question

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 08 Apr 2003 23:03:18 GMT
Message-ID: <MPG.18fcf50cc3b753f7989726@news.la.sbcglobal.net>


jeff.kish_at_mro.com said...
> I am not sure how the digits you can be sure of getting is determined if it is number(38).
> Will it save 7 or 8 of them? This is, I believe, the "scale". Since the data will vary so much,
> I am loath to dictate 7 or 8 digits in advance in case some have more digits to the left.
>
> How do I know the scale I can be "sure" of preserving?
>
> Obviously I am not as knowledgeable as I wish I was here...
>
> Thanks,
> Jeff Kish
>

You might want to head on over to http://asktom.oracle.com and search for "float" (without quotes) ... or jump right to this (which will probably wrap):

http://asktom.oracle.com/pls/ask/f?p=4950:8:1090762::NO::F4950_P8 _DISPLAYID,F4950_P8_CRITERIA:1416003959639,

-- 
/Karsten
DBA > retired > DBA
Received on Tue Apr 08 2003 - 18:03:18 CDT

Original text of this message

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