Oracle 11g NLS Parameters 확인방법[ORACLEJAVA커뮤니티자바오라클교육강좌오라클자바교육강좌,자바교육오라클교육]

Oracle 11g NLS Parameters 확인방법

오라클자바커뮤니티에서 설립한  개발자실무교육6년차 오엔제이프로그래밍 실무교육센터

(신입사원채용무료교육, 오라클, SQL, 튜닝, 자바, 스프링, Ajax, jQuery, 안드로이드, 아이폰, 닷넷, C#, ASP.Net)   www.onjprogramming.co.kr 

 

scott/tiger로 로그인 후

SQL> select * from nls_session_parameters;

PARAMETER                                                    VALUE                                                                           
------------------------------------------------------------ --------------------------------------------------------------------------------
NLS_LANGUAGE                                                 KOREAN                                                                         
NLS_TERRITORY                                                KOREA                                                                          
NLS_CURRENCY                                                 ￦                                                                             
NLS_ISO_CURRENCY                                             KOREA                                                                          
NLS_NUMERIC_CHARACTERS                                       .,                                                                             
NLS_CALENDAR                                                 GREGORIAN                                                                      
NLS_DATE_FORMAT                                              RR/MM/DD                                                                       
NLS_DATE_LANGUAGE                                            KOREAN                                                                         
NLS_SORT                                                     BINARY                                                                         
NLS_TIME_FORMAT                                              HH24:MI:SSXFF                                                                  
NLS_TIMESTAMP_FORMAT                                         RR/MM/DD HH24:MI:SSXFF                                                         
NLS_TIME_TZ_FORMAT                                           HH24:MI:SSXFF TZR                                                              
NLS_TIMESTAMP_TZ_FORMAT                                      RR/MM/DD HH24:MI:SSXFF TZR                                                     
NLS_DUAL_CURRENCY                                            ￦                                                                             
NLS_COMP                                                     BINARY                                                                         
NLS_LENGTH_SEMANTICS                                         BYTE                                                                           
NLS_NCHAR_CONV_EXCP                                          FALSE                                                                          

17 rows selected.

 

NLS_LANGUAGE     : DB에서 기본적으로 사용될 언어                                                                                                       
NLS_TERRITORY    : 해당언어와 사용할 지역 설정

 

이번엔 NLS_DATE_FORMAT을 세션 레벨에서 변경하자.

SQL>alter session set nls_date_format='dd-mon-rr'

Statement Processed.

SQL> select * from nls_session_parameters where parameter = 'NLS_DATE_FORMAT';

PARAMETER                                                    VALUE                                                                           
------------------------------------------------------------ --------------------------------------------------------------------------------
NLS_DATE_FORMAT                                              dd-mon-rr  

[출처] 오라클자바커뮤니티 - http://www.oraclejavanew.kr/bbs/board.php?bo_table=Oracle11&wr_id=2