Different methods to find out NLS Parameters from Oracle Database

advertisements

_____________________________________________________________________________________________________________________

1. Using SHOW PARAMETER

Connect / as sysdba

SQL> show parameter nls_

NAME                                 TYPE        VALUE

------------------------------------ ----------- -------------

nls_language                         string      AMERICAN

nls_territory                        string      AMERICA

2. From NLS_DATABASE_PARAMETERS

Connect / as sysdba

SQL> SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET')

PARAMETER                      VALUE

------------------------------ ------------------------------

NLS_LANGUAGE                   AMERICAN

NLS_TERRITORY                  AMERICA

NLS_CHARACTERSET               AL32UTF8

3. From NLS_SESSION_PARAMETERS

Connect / as sysdba

SQL> SELECT * FROM NLS_SESSION_PARAMETERS;

4. Using USERENV(‘language’) Function

Connect / as sysddba

SQL> SELECT USERENV ('language') FROM DUAL;

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

5. Using USERENV(‘lang’)

Connect / as sysdba

SQL> select userenv('lang') from dual;

USERENV('LANG')

----------------------------------------------------

US

US means NLS_LANGUAGE is set to American. If it is GB means then it is English.

6. From Database_properties table

select PROPERTY_NAME, PROPERTY_VALUE from database_properties where PROPERTY_NAME like '%NLS%';

_____________________________________________________________________________________________________________________

Website Stats