Different methods to find out NLS Parameters from Oracle Database


  1. Using SHOW PARAMETER
Connect / as sysdba
SQL> show parameter nls_

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------
nls_language                         string      AMERICAN
nls_territory                        string      AMERICA


  1. 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

  1. From NLS_SESSION_PARAMETERS
Connect / as sysdba
SQL> SELECT * FROM NLS_SESSION_PARAMETERS;

  1. Using USERENV(‘language’) Function

Connect / as sysddba
SQL> SELECT USERENV ('language') FROM DUAL;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
  1. 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.
  1. From Database_properties table
select PROPERTY_NAME, PROPERTY_VALUE from database_properties where PROPERTY_NAME like '%NLS%';
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google