Re: the result of "show parameter " is different from the result of "select * from v$nls_parameters"

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 29 Jul 2002 00:13:10 -0700
Message-ID: <92eeeff0.0207282313.40d2b228_at_posting.google.com>


wqhhust1_at_sina.com (wqhdebian) wrote in message news:<32c8bac7.0207281716.6754b5e0_at_posting.google.com>...
> when I use select * from v$nls_parameters
> the nls_language is "simplifed chinese"
>
> but nls_language in the result of command "show parameter" is American?
>
> and what is the real nls_language ?

When you use select * from v$nls_parameters, you see nls_language as setup on your client. Check value in registry at, HKLM\SOFTWARE\ORACLE\HOME[x]\[NLS_LANG]

When you say "Show parameters" or select * from v$parameter, you see parameters used by the database at startup. To see parameters as specified in the init.ora file of your database use, select * from v$parameter where upper(isdefault) = 'FALSE';

HTH
//Rauf Sarwar Received on Mon Jul 29 2002 - 09:13:10 CEST

Original text of this message