Re: Q: float data type

In article <7qmnd4$3k6$1_at_nnrp1.deja.com>,   tedchyn_at_yahoo.com wrote:
> Sir, Is there differences between data type number and data type
> float in defining a table ? number is well document in oracle manual
and
> float is not. Any comments is appreciated.
>
> Thanks Ted Chyn(tedchyn_at_yahoo.com)
>

Ted, try to check the archives as there was a post about two weeks ago on float and a bug on their behaviar in I believe ver 8 as compared to 7.3. Basically I believe Oracle stores floats as datatype number, but a declaration of float should limit the range of values that the column can hold to that of a 4 byte floating point numeric which may be less than the value that can be held in a column declared as number of the same size and scale. I seem to remember finding the post on the misc board, but it may have been cross posted.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 03 1999 - 08:11:46 CDT