Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number to float conversion
Hi Vittal,
No wonder you ask because is seems like a dumb idea to convert NUMBER to FLOAT. But the reason is that I am trying to use Microsoft ADO to access data from an Oracle database. ADO can handle the FLOAT datatype just fine, but when it comes to NUMBER it has some digestion problems.
See the posting "Problem using Oracle NUMBER datatype in ADO" on microsoft.public.ado and microsoft.public.vb.database newsgroups.
Best regards,
Henrik
In article <3710A4E3.35B33E1F_at_india.hp.com>,
"G.H VITTAL" <vittal_at_india.hp.com> wrote:
> I don't this it is possible. But why do you need when oracle
> itself support NUMBER(5,2) say to store 2 decimal values ?
>
> vittal
>
> henrik_m_at_my-dejanews.com wrote:
>
> > Hello,
> >
> > Is it possible to explicitly convert an Oracle NUMBER datatype to an Oracle
> > FLOAT datatype? I.e. something like
> > Select TO_FLOAT(4.55) from dual
> >
> > Best regards,
> > Henrik
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 12 1999 - 08:57:02 CDT