DBA

NLS_LANG 확인 하기 본문

[2] Database/ORACLE

NLS_LANG 확인 하기

코볼 2014. 3. 12. 09:57
728x90
반응형
SMALL

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

728x90
반응형
LIST
저작자표시 비영리 변경금지
'[2] Database/ORACLE' Related Articles more
Comments