Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number to float conversion
"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