Re: number format (0.5 instead of 0.5)

Hello,

let's talk in English for the other people which are interested in this thread.

Guido Konsolke schrieb:
 >
> (ENG) 1 (and best of all): RTFM. It's all in the SQL Reference. Have
> (ENG) a look at the function 'TO_NUMBER'.

I've already done that ... ;-)

> (ENG) 2: See the following (disgusting) example:
>
> select to_char(
> to_number ('0.5','0d0','nls_numeric_characters=''.,''')
> ,'0d0','nls_numeric_characters=''.,''')
> from dual;

The problem ist that i've got many tables with float-fields. And I do not want to write in every sql statement that function. I wanna set that somewhere global ...
ALTER SESSION SET NLS_.... = "0d0"
... but how?

Greetings from Rostock, Germany

Tino

-- 
Tino Korth                               Registered Linux User #286417
www.tinokorth.de - ICQ 10771191                  http://counter.li.org