Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

NLS_LANG setting in Database

edited Sep 16, 2013 4:44AM in Database Install/Upgrade/Opatch (MOSC) 9 commentsAnswered
Hi,  My new Database is installed on 11203  on Linux platform.

When I query using below it is showing my nls_lanaguge and territory is English and UK.

SQL>  show parameter nls_language

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_language                         string      ENGLISH
SQL>  show parameter nls_territory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_territory                        string      UNITED KINGDOM

But if I query by using below SQL it is giving nls_lang is American and Territory as Amereican

SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center