Re: Number to float conversion

Hint : I think you can write a pl/sql database function say conv_float() which returns float. Only thing you have to check up is whether you can convert a number to float in pl/sql.
Then you can code

  select conv_float(),

            col2,
from table
and spool the result to the file.

regards
vittal

henrik_m_at_my-dejanews.com wrote:

> 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 Tue Apr 13 1999 - 08:03:27 CDT