查询ORACLE数据库字符集

SQL> set linesize 2000
SQL> set pagesize 9000
SQL> SELECT (SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_LANGUAGE') || '_' ||
  2         (SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_TERRITORY') || '.' ||
  3         (SELECT VALUE
  4            FROM V$NLS_PARAMETERS
  5           WHERE PARAMETER = 'NLS_CHARACTERSET') || '"' NLS_LANG
  6    FROM DUAL;

NLS_LANG
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

SQL>