Re: number format (0.5 instead of 0.5)

(ENG) Hi Tino,
(DE) Hallo Tino,
(ENG) see my comments below...
(DE) Kommentare siehe unten...

"Tino Korth" wrote...

> 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

(ENG) 1 (and best of all): RTFM. It's all in the SQL Reference. Have
(ENG) a look at the function 'TO_NUMBER'.
(DE) Erster Rat: lies das überall im Internet einsehbare Handbuch, die
(DE) SQL Referenz. Schau dir die Funktion 'TO_NUMBER' an.

(ENG) 2: See the following (disgusting) example:
(DE) 2: Schau dir mein nachfolgendes (ekliges) Beispiel an:

select to_char(
to_number ('0.5','0d0','nls_numeric_characters=''.,''') ,'0d0','nls_numeric_characters=''.,''')
from dual;

(ENG) This is a bit confusing because of my nls settings.
(DE) Etwas verwirrend wg. meiner nls-Einstellungen.

hth,
Guido Received on Tue Sep 24 2002 - 12:48:42 CEST