Number to float conversion

Number to float conversion

Post by Mohamad SALE » Thu, 22 Apr 1999 04:00:00



"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



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;