Re: what datatype to use question

<snip>
>>>Thanks for your recommendations.
>>>Jeff
>>I'm leaning towards float. How can you tell the scale you get, i.e. number of digits to the right of the decimal point
>>with using a certain type? I looked at all_user_tables and did not see anything for scale.. Does this mean it stores
>>what it can?
>>
>>Thanks again,
>>Jeff
>
>REAL, FLOAT and DECIMAL have been designed for compatibility reasons
>and will all end up as NUMBER(38)
>
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
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 Received on Tue Apr 08 2003 - 16:09:40 CDT