Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Very simple questions
Just use the number(n,m) datatype, float is an acronym for number(38) Hopefully next time your brains are both capable to remember the answer and/or to search for it correctly in the sql reference manual.
Hth,
Sybrand Bakker, Oracle DBA
"Jeff Boyer" <jdboyer@(remove)icomproductions.ca> wrote in message
news:96ce54$naq$1_at_news3.cadvision.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?
>
> Thakns,
> Jeff
>
> P.S.
> I am using Oracle 8i
>
>
>
Received on Tue Feb 13 2001 - 23:07:04 CST