如何获取当前数据库的字符集设置？

Question

SQL> select * from nls_database_parameters;PARAMETER                                VALUE
---------------------------------------- -------------------
NLS_LANGUAGE                             AMERICAN
NLS_TERRITORY                            AMERICA
NLS_CURRENCY                             $
NLS_ISO_CURRENCY                         AMERICA
NLS_NUMERIC_CHARACTERS                   .,
NLS_CALENDAR                             GREGORIAN
NLS_DATE_FORMAT                          DD-MON-YY
NLS_DATE_LANGUAGE                        AMERICAN
NLS_CHARACTERSET                         ZHS16GBK
NLS_SORT                                 BINARY
NLS_NCHAR_CHARACTERSET                   ZHS16GBK
NLS_RDBMS_VERSION                        8.0.4.0.0查询到12记录.SQL> select * from V$NLS_PARAMETERS;PARAMETER                                VALUE
---------------------------------------- -------------------
NLS_LANGUAGE                             SIMPLIFIED CHINESE
NLS_TERRITORY                            CHINA
NLS_CURRENCY                             RMB
NLS_ISO_CURRENCY                         CHINA
NLS_NUMERIC_CHARACTERS                   .,
NLS_CALENDAR                             GREGORIAN
NLS_DATE_FORMAT                          DD-MON-YY
NLS_DATE_LANGUAGE                        SIMPLIFIED CHINESE
NLS_CHARACTERSET                         ZHS16GBK
NLS_SORT                                 BINARY
NLS_NCHAR_CHARACTERSET                   ZHS16GBK查询到11记录.

Answer 1

sp_server_info or sp_helpsort

Answer 2

select * from v$nls_parameters;
看NLS—LANG
NLS_LANG = language_territory.charset 
有三个组成部分（语言、地域和字符集其中：
language 指定服务器消息的语言。 
territory 指定服务器的日期和数字格式。 
Charset 指定字符集