Sunday, May 13, 2007

Globalization settings

Views holding the NLS parameters.
In ascending order of priority:

select * from nls_database_parameters;
select * from nls_instance_parameters;


To get your currently active settings:
select * from nls_session_parameters;
or a more complete version: v$nls_parameters

No comments: