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>