Re: Very simple questions

From: Jeff Boyer <jdboyer_at_(remove)icomproductions.ca>
Date: Thu, 15 Feb 2001 09:32:12 -0700
Message-ID: <96h462$7mo$1@news3.cadvision.com>

Thanks for the advice, I will keep the stupid questions to a minimum from now on. haha

Jeff
"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3A8A264E.F3679E06_at_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 Thu Feb 15 2001 - 10:32:12 CST