Hi All,
Does any view provide the information of all NLS parameters thet the system is currently using.
Cheers,
Paddy
Printable View
Hi All,
Does any view provide the information of all NLS parameters thet the system is currently using.
Cheers,
Paddy
Hi,
you can query these views to obtain a list of current NLS parameters in the database:
NLS_SESSION_PARAMETERS;
NLS_INSTANCE_PARAMETERS;
NLS_DATABASE_PARAMETERS;
You can view the entire list of parameters and values using :
V$NLS_PARAMETERS;
V$NLS_VALID_VALUES;
Cheers.