Re: Very simple questions

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 13 Feb 2001 22:31:42 -0800
Message-ID: <3A8A264E.F3679E06@exesolutions.com>

> I appologize for the simplicity of this question but I have forgotten the
> answer. I need to use a data type in my tables that will allow me to store
> numbr values with decimal places. Is there a data type "float" in Oracle
> and should I use this data type? I have looked around in my refernce guide
> and on the net and can't seem to find out exactly what data type to use. If
> I do use float would I use it like:
>
> Score Float(2) NULL,
>
> or is there anohter way to use it?

You can definitely define fields in Oracle tables using FLOAT. But both FLOAT and INTEGER are just subsets of the NUMBER type. You could define the same type of field as NUMBER(10,5) for example.

Daniel A. Morgan Received on Wed Feb 14 2001 - 00:31:42 CST