Re: How do I find out the language of an instance?

From: Someone <tsbsps_at_nospam.ca>
Date: 1997/09/19
Message-ID: <3422BEFE.6BBE@nospam.ca>#1/1

masint_at_istar.ca wrote:
>
> In article <01bcc392$748bece0$af0ba8c0_at_pc240smo.mbo.sds.intra>,
> "Scott Overby" <scott.overby_at_sdsdata.com> wrote:
> >
> >
> > How do I find out the language that an instance was created as?
> >
> > --
> > ==========================================================================
> > Scott Overby E-mail scott.overby_at_sdsdata.com
> > Sr. Systems Analyst Phone (414) 459-7999
> > INPire Insurance Solutions FAX (414) 459-9123
> > 615 Penn Ave.
> > Sheboygan, WI 53082
> >
> > _/_/_/ _/_/ _/ _/_/_/ \ | /
> > _/ _/ _/ _/ _/ \ | /
> > _/ _/ _/ _/ _/_/_/ _/_/_/_/ _/ _/_/_/ _/_/_
> > _/ _/ _/_/ _/ _/ _/ _/ _/ _/ _/ _/
> > _/_/_/ _/ _/ _/_/_/ _/_/_/_/ _/ _/ _/_/_/
> > _/
> > _/
> > ===========================================================================
>
> Look at the VALUE$ column value in SYS.PROPS$ where the NAME column =
> 'NLS_CHARACTERSET'.
>
> Michael
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

I think you can also look at a view from sqlplus:

SELECT * FROM V$NLS_PARAMETERS; This lists nls stuff including the character set. Received on Fri Sep 19 1997 - 00:00:00 CDT