Re: Float versus number

From: Jerry Gitomer <jgitomer_at_hbsrx.com>
Date: Tue, 19 Oct 1999 13:04:56 -0400
Message-ID: <7ui8uj$fgi$1@autumn.news.rcn.net>

No.

Oracle allocates space for numbers at the time they are stored. It uses a proprietary scheme quite similar to floating point so your declaration doesn't make any difference.

hth
jerry gitomer

Frank Calfo wrote in message
<01bf19b7$b42fbc00$e401010a_at_FRANK>...
>If I define a column as "float" will it take up any more space
than if I
>declare it as number (11,4) ?
>
>Is "float" one of those datatypes that should be used only when
absolutely
>necessary or can it be used without too much grief?
>
Received on Tue Oct 19 1999 - 12:04:56 CDT