Re: Q: float data type

There is an interesting difference though. You (implicitly) specify a decimal place in number(p,s), but a float(n) has only a precision which can 'float'.

Create table t1 (n1 float(12));
insert into t1 values (12345);
insert into t1 values (0.12345);

select * from t1;

   123450
   0.1235

Given sufficiently extreme arithmetic,
float(N) can survive longer than number(p,s)

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Thomas Kyte wrote in message ...

>No, I think I would want to use numbers with 38 digits of precision/scale.
The
>Oracle number type has more precision/scale then a float type does.
>
Received on Wed Sep 08 1999 - 09:08:55 CDT