How to Check Database Language,Territory and Character Set

select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER_SET','NLS_LANGUAGE', 'LANGUAGE','NLS_TERRITORY', 'TERRITORY') name,value

from v$nls_parameters

WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');


NAME                                         VALUE

------------------------------------------------------------------

LANGUAGE                                AMERICAN

TERRITORY                                AMERICA

CHARACTER_SET                       AL32UTF8

Comments