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