Re: retrieve nls_lang out of db ?

Whoops! Sorry, too fast answer!
v$nls_parameters gives you your current nls parameters except NLS_CHARACTERSET.

You can get it in HKLM\Software\Oracle\NLS_LANG on NT, or with !echo $NLS_LANG with Unix/Sql*Plus, or with getenv funtion in C...

I don't know if it's possible with pure SQL.

--
Regards
Michel


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


> In article <94op2n$e9r$1_at_s1.read.news.oleane.net>,

>   "Michel Cadot" <micadot_at_netcourrier.com> wrote:

> > You can find your current settings of nls parameters in

 v$nls_parameters.


> >

> > --

> > Have a nice day

> > Michel

> >

>

> Hi Michael,

>

> thanks for your reply, but I think, you are wrong.

> With v$nls_parameters, you get NLS_CHARACTERSET,

> which is the characterset of the database, not the one, your

> client is using in fact

> (just set NLS_LANG=america_american.us7ascii, use sqlplus

>  and query v$nls_parameters, it will show you the characterset

> of the database)

>

> Anyway, thanks

>  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/