Re: NUMBER datatype

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Mon, 16 Aug 1999 09:16:58 -0400
Message-ID: <7p9354$68n$1@autumn.news.rcn.net>

No. Number fields are stored in a format similar to floating point, but with a variable number of fraction bytes. The number of bytes is sufficient to assure accurate results.

regards
Jerry Gitomer

gregk72_at_my-deja.com wrote in message
<7ovtvl$2vq$1_at_nnrp1.deja.com>...
>Q about the NUMBER datatype
>
>If I do an ANALYZE TABLE on a table with NUMBER fields, it
always
>reports that NUMBER fields take 22 bytes regardless of the
precision and
>scale. Do all NUMBER fields actually take 22 bytes, or is the
size
>variable by the precision and scale.
>
>Thanks.
>
>- Greg
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Aug 16 1999 - 08:16:58 CDT