Search notes:

Oracle: V$NLS_PARAMETERS

NLS parameters that are in effect.
select
  lower(parameter) parameter_name
-- value
from
  v$nls_parameters order by 1;
--
-- nls_calendar
-- nls_characterset
-- nls_comp
-- nls_currency
-- nls_date_format
-- nls_date_language
-- nls_dual_currency
-- nls_iso_currency
-- nls_language
-- nls_length_semantics
-- nls_nchar_characterset
-- nls_nchar_conv_excp
-- nls_numeric_characters
-- nls_sort
-- nls_territory
-- nls_time_format
-- nls_timestamp_format
-- nls_timestamp_tz_format
-- nls_time_tz_format
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/nls/parameters/names.sql

See also

v$nls_valid_values
Oracle Dynamic Performance Views
The SQL Developer menu Tools -> Preferences -> Database -> NLS.

Index