Re: number format (.5 instead of 0.5)

If you are doing this in SQL*Plus, use the format option for the column to display:

SQL> create table number_test (a number);

Table created.

SQL> insert into number_test values (.5);

1 row created.

SQL> col a format 999,990.99
SQL> select * from number_test;

          A

       0.50

SQL> col a format 999,990.9
SQL> select * from number_test;

         A

       0.5

"Tino Korth" <newsgroup_at_tk79.de> wrote in message news:ampa2j$3tp$1_at_nntp-m01.news.aol.com...
> Hello,
>
> I've got a float field with the value ".5" (I've insertet a "0.5"-value,
> but Oracle formats the value to ".5").
> How can I "re"format the float when I'm SELECTing this value? I wanna
> have "0.5" as a return value.
>
>
> Greetings from Rostock, Germany!
>
> Tino
>
> --
> Tino Korth Registered Linux User #286417
> www.tinokorth.de - ICQ 10771191 http://counter.li.org
>
>
Received on Tue Sep 24 2002 - 18:56:38 CDT