Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nls_numeric_character checking function
"Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:411a507f$0$3189$626a14ce_at_news.free.fr...
>
> "FC" <flavio_at_tin.it> a écrit dans le message de
> news:2bd78ddf.0408110828.588447e5_at_posting.google.com...
> > I don't know if it is a FAQ,I couldn't find anything with google,
> > anyway here is a simple query returning the session values
> > corresponding to the NLS_NUMERIC_CHARACTER parameter.
> >
> > select translate(trim(to_char(1,'L9')),' 1',' ') L,
> > translate(trim(to_char(11,'9G9')),' 1',' ') G,
> > translate(trim(to_char(1.1,'9D9')),' 1',' ') D,
> > translate(trim(to_char(1,'C9')),' 1',' ') C from dual;
> >
> > Bye,
> > Flavio
>
> For D and G:
> select value from v$nls_parameters where
parameter='NLS_NUMERIC_CHARACTERS';
> select value from nls_session_parameters where
parameter='NLS_NUMERIC_CHARACTERS';
>
> Idem for C with NLS_ISO_CURRENCY.
> Idem for L with NLS_CURRENCY
>
> --
> Regards
> Michel Cadot
>
>
This happens when one searches "NLS_NUMERIC" using Oracle's documentation built-in search (as well as google) and nothing is returned...
:-)
Thanks Michel! Received on Thu Aug 12 2004 - 10:03:43 CDT