Re: Storing large numbers, NUMBER datatype questions

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 26 Apr 2006 07:29:51 GMT
Message-ID: <1146036590.717447@proxy.dienste.wien.at>

tadamsmar_at_yahoo.com wrote:
> We are running into large numbers needing to be stored in some columns.
>
> Does increasing the precision of a NUMBER increase the storage size?
>
> What are the consequences of using NUMBER without precision or scale?

In addition to the pointers that the others have given, I would like to draw your attention to the BINARY_FLOAT and BINARY_DOUBLE data types introduced in Oracle 10g.

Yours,
Laurenz Albe Received on Wed Apr 26 2006 - 02:29:51 CDT