Checking NLS Parameters in Oracle Database

 

#Query to check NLS parameters in Oracle database SQL> set lines 300 pages 3000 SQL> col property_name for a30 SQL> col property_value for a30 SQL> select property_name,property_value from database_properties where property_name like '%NLS%' order by 1; PROPERTY_NAME            PROPERTY_VALUE ------------------------ ---------------------------- NLS_CALENDAR             GREGORIAN NLS_CHARACTERSET         AL32UTF8 NLS_COMP                 BINARY NLS_CURRENCY             $ NLS_DATE_FORMAT          DD-MON-RR NLS_DATE_LANGUAGE        AMERICAN NLS_DUAL_CURRENCY        $ NLS_ISO_CURRENCY         AMERICA NLS_LANGUAGE             AMERICAN NLS_LENGTH_SEMANTICS     BYTE NLS_NCHAR_CHARACTERSET   AL16UTF16 NLS_NCHAR_CONV_EXCP      FALSE NLS_NUMERIC_CHARACTERS   ., NLS_RDBMS_VERSION        19.0.0.0.0 NLS_SORT                 BINARY NLS_TERRITORY            AMERICA NLS_TIMESTAMP_FORMAT     DD-MON-RR HH.MI.SSXFF AM NLS_TIMESTAMP_TZ_FORMAT  DD-MON-RR HH.MI.SSXFF AM TZR NLS_TIME_FORMAT          HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT       HH.MI.SSXFF AM TZR