Re: FLOAT Data Types under 8i?

From: Eric Kimble <ekimble_at_wfl.fha.dot.gov>
Date: Tue, 21 Jan 2003 10:31:28 -0800
Message-ID: <3E2D9200.A07BC4F2@wfl.fha.dot.gov>

You want to use the number datatype in the format number(6,2) This will create the datatype that you need and allow you to perform numeric functions without datatype conversions.

Rhugga wrote:

> 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 - 12:31:28 CST