NLS_LANG 확인 하기

sysdba로 로그인

 

 

select * from props$ where name = 'NLS_CHARACTERSET';

[결과]

SQL> select * from props$ where name='NLS_CHARACTERSET';

NAME
------------------------------
VALUE$
---------------------------------------------------------

COMMENT$
---------------------------------------------------------

NLS_CHARACTERSET
KO16MSWIN949
Character set

 

select * from v$nls_parameters where parameter = 'NLS_CHARACTERSET';

[결과]
SQL> select * from v$nls_parameters where parameter = 'NLS_CHARACTERSET';

PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
KO16MSWIN949

 

 

select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

[결과]
SQL> select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
KO16MSWIN949