Re: number format (0.5 instead of 0.5)

From: Guido Konsolke <gk61_at_gmx.net>
Date: Tue, 24 Sep 2002 13:58:31 +0200
Message-ID: <1032868297.472233_at_news.thyssen.com>


Hi Tino,
please have a look below your posting...

"Tino Korth" <newsgroup_at_tk79.de> wrote...
> 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
>

afaik you're kinda stuck. There is no
'alter session set nls_number_format' or something like that. So the only way I can think of would be to write a little function that does the formatting and returns the formatted value.
I know this is not want you really want
but if no one else has a better idea... eat it.

Greetings from Bochum, Germany
Guido
P.S.: Hope to see Hansa and VfL on top of Bundesliga again... Received on Tue Sep 24 2002 - 13:58:31 CEST

Original text of this message