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