Get server language/character/time format

--language

select parameter,value

from nls_database_parameters

whereparameter = 'NLS_LANGUAGE';

 

 

--character

select parameter, value

from nls_database_parameters

whereparameter = 'NLS_CHARACTERSET';

 

--date format

select parameter, value

 from nls_database_parameters

 whereparameter = 'NLS_DATE_FORMAT';