Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: FLOAT & NUMBER

Re: FLOAT & NUMBER

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/06/03
Message-ID: <heugjs0b6ib5fmcaic1r0f6ehp4e6970gq@4ax.com>#1/1

The following two declarations are identical:

	x number
	x float

Declaring a column as NUMBER, but without a precision and scale results in a floating-point value. FLOAT is just another keyword that Oracle threw in to provide compatibility with other SQL dialects.

Jonathan



jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Fri, 2 Jun 2000 21:47:02 +0200, "CHC" <qi.xiang.chi_at_icu.nl> wrote:

>FLOAT isn't internal Oracle type, NUMBER is.
>Is it true that NUMBER is more efficient than FLOAT ?
Received on Sat Jun 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US