Using Numeric Formats
Establishing a Globalization Support Environment
Working in a Global Environment 6-17
Under Connections, expand Data Dictionary reports, then About Your Database,
and then National Language Support Parameters. In the Select Connection dialog
box, select
hr_conn
from the list of connections. The current date format is listed
after
NLS2008FORMAT
and the current territory is listed after
NLS_CALENDAR
.
2.
Set
NLS_CALENDAR
to English Hijrah.
ALTER SESSION SET NLS_CALENDAR='English Hijrah';
3.
Display the start of Ramadan for the year 1424 H (in Gregorian calendar year
2007).
SELECT TO_DATE('01-Ramadan-1428') FROM DUAL;
The output from the example should be similar to the following.
TO_DATE('01-RAMADAN-1428')
-------------------------
13 September 2007
4.
Set
NLS_CALENDAR
back to its original setting listed in Step 1. For example:
ALTER SESSION SET NLS_CALENDAR='GREGORIAN';
Using Numeric Formats
The database must know the number-formatting convention used in each session to
interpret numeric strings correctly. For example, the database needs to know whether
numbers are entered with a period or a comma as the decimal character (234.00 or
234,00). Similarly, applications must be able to display numeric information in the
format expected at the client site.
Examples of numeric formats are shown in the following table.
Numeric formats are derived from the
NLS_TERRITORY
parameter setting, but they
can be overridden by the
NLS_NUMERIC_CHARACTERS
parameter.
See Also:
Oracle Database Reference for more information on the
NLS_
CALENDAR
parameter
Oracle Database Globalization Support Guide for locale information,
including supported calendars
Country
Numeric Formats
Estonia
1 234 567,89
Germany
1.234.567,89
China
1,234,567.89
UK
1,234,567.89
U.S.
1,234,567.89
See Also:
Oracle Database Globalization Support Guide for a complete
discussion of setting up the globalization support environment
