Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: retrieve nls_lang out of db ?

Re: retrieve nls_lang out of db ?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 25 Jan 2001 09:44:16 +0100
Message-ID: <94op2n$e9r$1@s1.read.news.oleane.net>

You can find your current settings of nls parameters in v$nls_parameters.

--
Have a nice day
Michel


"Thomas Schwickert" <thomas.schwickert_at_itellium.com> a écrit dans le message news:
94n0ck$b7o$1_at_nnrp1.deja.com...

> Hello,
>
> sorry, but I didn't find an answer to this question anywhere ...
>
> Is it possible to get the ACTUAL setting for the used characterset
> of a client ?
> What I mean, if I set the NLS_LANG to some proer value,
> and use sqlplus, can I retrieve the value for NLS_LANG
> out of the database ?
>
> With nls_database_parameters, you only get the database characterset,
> not the actually used by the client...
>
> Thanx in advance
> Thomas
>
> --
> --
> Thomas Schwickert Phone: +49 69 - 404 8093
> Itellium System & Services GmbH Fax: +49 69 - 404 5561
> 60386 Frankfurt
> Germany
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 25 2001 - 02:44:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US