background image
<< Setting NLS_NUMERIC_CHARACTERS Parameter | Using the NLS_ISO_CURRENCY Parameter >>
<< Setting NLS_NUMERIC_CHARACTERS Parameter | Using the NLS_ISO_CURRENCY Parameter >>

Using Monetary Parameters

Establishing a Globalization Support Environment
Working in a Global Environment 6-19
Using Monetary Parameters
You can define radix symbols and thousands separators by locales. For example, in the
U.S., the decimal point is a period (.), while it is a comma (,) in France. Because $1,234
has different meanings in different countries, it is important to display the amount
appropriately by locale.
Overview of Currency Formats
Different currency formats are used throughout the world. Some typical formats are
shown in the following table.
Using the NLS_CURRENCY Parameter
The
NLS_CURRENCY
parameter specifies the character string returned by the
L
number
format model, the local currency symbol. Setting
NLS_CURRENCY
overrides the default
setting defined implicitly by
NLS_TERRITORY
. The value can be any valid currency
symbol string.
To see the effect of changing the NLS_CURRENCY value:
The following example displays salary amounts using a format that includes the
L
number format model, which is replaced by the NLS_CURRENCY value.
1.
Display salaries with a value greater than eleven thousand.
See Also:
Oracle Database Reference for more information on the
NLS_
NUMERIC_CHARACTERS
parameter
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment
See Also:
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment,
including monetary parameters
Country
Currency Format
Estonia
1 234,56 kr
Germany
1.234,56
China
¥1,234.56
UK
£1,234.56
U.S.
$1,234.56
See Also:
Using the NLS_CURRENCY Parameter
on page 6-19
Using the NLS_ISO_CURRENCY Parameter
on page 6-20
Using the NLS_DUAL_CURRENCY Parameter
on page 6-21
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment,
including monetary parameters