Check current value NLS parameter in session of Oracle

Check the current value of NLS_TERRITORY, NLS_CURRENCY, NLS_CALENDAR, NLS_DATE_FORMAT, NLS_DATE_LANGUAGE & NLS_SORT in Session of Oracle

NLS_TERRITORY: Show the territory of the current session.

SQL> SELECT SYS_CONTEXT('USERENV','NLS_TERRITORY') "NLS_TERRITORY" from dual;

NLS_TERRITORY
--------------
AMERICA

NLS_CURRENCY: Show the currency of the current session.

SQL> SELECT SYS_CONTEXT('USERENV','NLS_CURRENCY') "NLS_CURRENCY" from dual;
NLS_CURRENCY
---------------
$

NLS_CALENDAR: Show the current calendar of the current session.

SQL> SELECT SYS_CONTEXT('USERENV','NLS_CALENDAR') "NLS_CALENDAR" from dual;

NLS_CALENDAR
----------------
GREGORIAN

NLS_DATE_FORMAT : Show the date format for the session.

SQL> SELECT SYS_CONTEXT('USERENV','NLS_DATE_FORMAT') "NLS_DATE_FORMAT" from dual;

NLS_DATE_FORMAT
-----------------
DD-MON-RR

NLS_DATE_LANGUAGE: Show the language used for date.

SELECT SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE') "NLS_DATE_LANGUAGE" from dual;

NLS_DATE_LANGUAGE
--------------------
AMERICAN

NLS_SORT : Show what sort used binary or char.

SQL> SELECT SYS_CONTEXT('USERENV','NLS_SORT') "NLS_SORT" from dual;

NLS_SORT
-----------
BINARY

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.