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

Thread: NLS Parameters

  1. #1
    Join Date
    Jan 2002
    Location
    Amsterdam
    Posts
    25

    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
    Location
    Slovenia
    Posts
    422
    Yes, at the start of the session do
    alter session set nls_territory='AMERICA';
    Tomaž
    "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