Thursday, 27 October 2011

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.

No comments:

Post a Comment