Re: FLOAT Data Types under 8i?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 22 Jan 2003 06:10:01 +1100
Message-ID: <qMgX9.29687$jM5.76808@newsfeeds.bigpond.com>

Oracle has only one number datatype: NUMBER.

Declared merely as NUMBER, it can store numbers up to 38 digits in length, with a decimal point anywhere within that. It is an inherently variable-length data type, however, so if you then stored the entry '100.35', it would only take up the space of those supplied 6 characters, not the space of the 38 possible.

Or you could declare it as a number(6,2), meaning that there are 6 digits in total, two of which are after the decimal point (which covers your case of 1000.00), though again the thing is variable, and the actual number can be UP to 6 digits in total, but if you only supply 3 (ie, 3.55) that's what will be stored.

Regards
HJR "Rhugga" <root_at_syrrx.com> wrote in message news:3E2D80EA.3090106_at_syrrx.com...
>
> Are there no float datatypes in Oracle 8i? If not, what is the best var
> for storing floating point number that will never be greater than say
> 1000 with a 2 decimel point precision?
>
>
> Thanks,
> CC
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Tue Jan 21 2003 - 13:10:01 CST