CODEWITHSUNDEEP
sqloracle-databaseplsql
Arav
Arav

Reputation: 5247

What is the purpose of NLSTERRITORY session variable in Oracle?

What is the purpose of NLSTERRITORY session variable in Oracle? If I change NLSTERRITORY point to a different country what does it do? Does it change any date parameter? Because always 10Nov2010 is Wednesday. What difference does it make if I change the territory?

Upvotes: 2

Views: 232

Answers (1)

OMG Ponies
OMG Ponies

Reputation: 332521

Quote:

Specifying an NLS parameter means that any User Session NLS parameters (or the lack of) will not affect evaluation of [the query/function/stored procedure/etc].

The language and territory components of NLS_LANG set the default values for the other NLS parameters, such as:

  • date format
  • numeric characters
  • collation

Reference:

Upvotes: 2

Related Questions