▷ Oracle characterset query/update (오라클 케릭터셋 조회/변경)

[ Oracle characterset ]

(1) 조회
select * from sys.props$ where name='NLS_CHARACTERSET';

(2) 변경
update sys.props$  set value$='KOREAN_KOREA.KO16MSWIN949' where name='NLS_CHARACTERSET';

-- AREMERICAN_AMERICA.AL32UTF8

-- AL32UTF8

(3) 적용
DB shutdown -> startup