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 |