Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: what datatype to use question
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 > DBAReceived on Tue Apr 08 2003 - 18:03:18 CDT