Oracle 11g NLS Parameters 확인방법[ORACLE/SQL/HINT/오라클/교육/강의/강좌/SQL교육/오라클 PLSQL/강의/강좌/오라클교육/ORACLE초보교육/오라클실무강좌]

Oracle 11g NLS Parameters 확인방법   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     오라클자바커뮤니티교육센터, 개발자전문교육, 개인80%환급  www.oraclejavacommunity.com 평일주간(9:30~18:10) 개강 (6/23)[기업100%환급]자바기초에서 JDBC, Servlet/JSP까지  (6/23)[기업100%환급]Spring ,MyBatis,Hibernate실무과정 (6/23)[기업100%환급]SQL기초에서 Schema Object까지 (6/30)[기업100%환급]PL/SQL,ORACLE HINT,TUNING (6/30)[기업100%환급]안드로이드개발자과정 (7/07)[기업100%환급]C#4.0,WinForm,ADO.NET프로그래밍 (7/07)[채용예정교육]오라클자바개발잘하는신입뽑기프로젝트,교육전취업확정 평일야간(19:00~21:50) 개강 (6/19)웹퍼블리싱 마스터 (6/19)Spring3.X, MyBatis, Hibernate실무과정 (6/24)안드로이드개발자과정 (6/24)MyBatis3.X, Hibernate4.X ORM실무과정 (6/26)SQL초보에서실전전문가까지 (7/01)닷넷(C#,Network,ADO.NET,ASP.NET)마스터과정 (7/02)자바웹(JSP,Spring,MyBatis,XPlatform)프로젝트과정 (7/02)JAVA,Network&WEB&Framework(자바기초에서웹스프링까지) (7/22)자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 주말(10:00~17:50) 개강 (6/21)Spring3.X, MyBatis, Hibernate실무과정 (6/21)MyBatis3.X, Hibernate4.X ORM실무과정 (6/21)자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 (6/28)SQL초보에서 Schema Object까지 (6/28)안드로이드개발자과정 (6/28)개발자를위한PLSQL,SQL튜닝,힌트 (6/28)실무예제로 배워보는 jQuery(개발자/디자이너를위한) (6/28)자바웹(JSP,Spring,MyBatis,XPlatform)프로젝트과정 (7/13)C#,ASP.NET마스터 주말저녁(18:30~22:20) 개강 (6/28)JAVA,Network&WEB&Framework (6/28)SQL기초에서실무까지