Oracle Characterset

SELECT * FROM sys.props$ where name='NLS_CHARACTERSET';

SELECT * FROM sys.props$ where name='NLS_NCHAR_CHARACTERSET';

SELECT * FROM sys.props$ where name='NLS_LANGUAGE';

SELECT * FROM sys.props$ where name like '%CHARACTERSET%';

update sys.props$ set value$='UTF8' where name='NLS_CHARACTERSET';

update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET';

update sys.props$ set value$='KOREAN_KOREA.UTF8' where name='NLS_LANGUAGE';

데이타베이스의  CHARACTER SET은 데이타 딕셔너리 테이블인 sys.props$에

 들어 있다

SQL>desc sys.props$

SQL>column c1 format a30 

SQL>select name c1, value$ c1 from sys.props$;

출처  : https://keichee.tistory.com/65

출처 : http://jehna.tistory.com/36