[Oracle] NLS Data Format Alter

# OS에서 SYSDBA로 SQLPLUS 접속

oracle$ sqlplus / as sysdba

SQL> alter system set nls_date_format='DD-MON-RR' scope=spfile;

SQL> alter system set nls_date_language='AMERICAN' scope=spfile;

SQL> alter system set nls_iso_currency='AMERICA' scope=spfile;

SQL> alter system set nls_language='AMERICAN' scope=spfile;

SQL> alter system set nls_territory='AMERICA' scope=spfile;

SQL> alter system set nls_time_format='HH.MI.SSXFF AM' scope=spfile;

SQL> alter system set nls_time_tz_format='HH.MI.SSXFF AM TZR' scope=spfile;

SQL> alter system set nls_timestamp_format='DD-MON-RR HH.MI.SSXFF AM' scope=spfile;

SQL> alter system set nls_timestamp_tz_format='DD-MON-RR HH.MI.SSXFF AM TZR' scope=spfile;

SQL> startup force;  è DB 재시작

SQL> show parameter nls  è 잘 변경되었는지 확인