Re: Number to float conversion

From: G.H VITTAL <vittal_at_india.hp.com>
Date: Sun, 11 Apr 1999 19:04:27 +0530
Message-ID: <3710A4E3.35B33E1F@india.hp.com>

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
Received on Sun Apr 11 1999 - 08:34:27 CDT