오라클 한글깨짐

SELECT NAME,VALUE$ FROM PROPS$ WHERE NAME ='NLS_LANGUAGE' OR NAME select * from v$nls_parameters; or select * from propS$ where NAME LIKE 'NLS_%';

UPDATE SYS.PROPS$ SET VALUE$='KO16MSWIN949' WHERE NAME='NLS_CHARACTERSET';

UPDATE SYS.PROPS$ SET VALUE$= '=KOREAN_KOREA.KO16MSWIN949' WHERE NAME='NLS_LANGUAGE';

재기동

[출처] 오라클 한글 깨짐|작성자 오라클마스터