select (select value
from nls_database_parameters
where parameter = 'NLS_LANGUAGE') || '_' ||
(select value
from nls_database_parameters
where parameter = 'NLS_TERRITORY') || '.' ||
(select value
from nls_database_parameters
where parameter = 'NLS_CHARACTERSET')
from dual