Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Number to float conversion

Re: Number to float conversion

From: Mohamad SALEH <msaleh_at_orsys.fr>
Date: Wed, 21 Apr 1999 14:42:27 +0200
Message-ID: <371DC7B3.BD6A321F@orsys.fr>


"G.H VITTAL" a écrit :

> 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:
>

I think this conversion is done implicitly! i.e. if you have x of type NUMBER and y of type FLOAT
you can issue in PL/SQL the statement without any problem : y := x; Received on Wed Apr 21 1999 - 07:42:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US