NLS_DATABASE_PARAMETERSselect * from NLS_INSTANCE_PARAMETERS select * from NLS_SESSION_PARAMETERS
The one actually take affect is NLS_SESSION_parameter which is your Registery setting
nls_language and nls_territory are the server-side initial parameters, whereas the nls_lang is client-side.the nls_lang will override the values of nls_language and nls_territory.if you issue the statement listed below, you will see the right result. select * from nls_session_parameter
那么database character set和national character set,我怎么看得到呢? 这两个值谁能解释一下? 我记得我建库的时候的字符集是ZHS16GBK,而select * from NLS_INSTANCE_PARAMETERS看到的nls_language的值是american,这两个值和nls_langugae有什么关系吗?
select * from NLS_SESSION_PARAMETERS
select * from nls_session_parameter
这两个值谁能解释一下?
我记得我建库的时候的字符集是ZHS16GBK,而select * from NLS_INSTANCE_PARAMETERS看到的nls_language的值是american,这两个值和nls_langugae有什么关系吗?