Obtaining NLS information

To get NLS information do:

select * from v$nls_parameters;

This select will give you:

• NLS_LANGUAGE
• NLS_TERRITORY
• NLS_CURRENCY
• NLS_ISO_CURRENCY
• NLS_NUMERIC_CHARACTERS
• NLS_CALENDAR
• NLS_DATE_FORMAT
• NLS_DATE_LANGUAGE
• NLS_CHARACTERSET
• NLS_SORT
• NLS_NCHAR_CHARACTERSET

You can also use nls_database_parameters to get the same result.