-
NLS Parameters
Hi all!
The other day I asked how I could let the first day of the week be set to sunday. Somone suggested that changing NLS_TERRITORY to AMERICA would do the trick. It did! Great!
However, when I use a client program here (like TOAD) it says that my session NLS Paramteres are set according to my locale, Europe! Now I have come to realize that the NLS parameters are not always the same from database to instance to session. Is there any way I can set my session (and instance) NLS parameters without having to change my locale on my pc?
In advance I thank all replies.
-
Yes, at the start of the session do
alter session set nls_territory='AMERICA';