Re: the result of "show parameter " is different from the result of "select * from v$nls_parameters"
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