DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: NLS Parameters

  1. #1
    Join Date
    Jan 2002

    Question 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.

  2. #2
    Join Date
    Jul 2001
    Yes, at the start of the session do
    alter session set nls_territory='AMERICA';
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.