NLS_LANG setting in Database
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 .,