NLS_CURRENCY

The NLS_CURRENCY option specifies the local currency symbol for the L number format element for the session. (See the TO_NUMBER function for a description of number format elements.

Within a session, you can dynamically modify the value of this option using the OLAP DML syntax show below or by using the SQL statement ALTER SESSION SET option = value.  

Data Type

TEXT

Syntax

NLS_CURRENCY = option-value

Parameters

See Oracle Database Globalization Support Guide for more information about NLS parameters, including valid values.