Oracleデータベースは多言語対応されており、様々な国や地域に応じた日付フォーマットや通貨記号、数字の桁区切り文字に対応しています。それぞれの国や地域毎の表記を確認する方法を紹介したいと思います。
様々な国や地域で使用されている日付フォーマットや通貨記号、数字の桁区切り文字はどのようなものなのか、SQLだけで確認することが出来ます。このSQLを利用することで各国に対応した日付や通貨記号、数字の桁区切り文字を確認したり利用することが出来ます。
国や地域の日付フォーマット、通貨記号、数字の桁区切り文字を取得する
様々な国や地域の日付フォーマット、通貨記号、数字の桁区切り文字などの表記を確認するには、次のようなSQLを実行します。
CREATE OR REPLACE FUNCTION my_nls_territory_defaults(t VARCHAR2)
RETURN VARCHAR2 AS
s VARCHAR2(2048) := '';
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TERRITORY = ''' || t || '''';
FOR i IN (SELECT * FROM nls_session_parameters
WHERE parameter IN
('NLS_DATE_FORMAT', 'NLS_NUMERIC_CHARACTERS', 'NLS_CURRENCY', 'NLS_ISO_CURRENCY')
ORDER BY parameter DESC)
LOOP
s := s || LPAD(i.parameter, 20) || '=' || RPAD(i.value, 20);
END LOOP;
RETURN s || ' 例: ' || TO_CHAR(TRUNC(SYSDATE, 'yy') - 1, 'ds');
END;
/
SELECT RPAD(value, 20) || my_nls_territory_defaults(value) AS "NLS_TERRITORY_DEFAULT" FROM v$nls_valid_values WHERE parameter = 'TERRITORY' ORDER BY 1;
DROP FUNCTION my_nls_territory_defaults;このSQLを実行すると次のような結果が得られます。国や地域毎の数字の桁区切り文字、日付フォーマット、通貨記号、そして日付のフォーマット例を表示しています。
SQL> CREATE OR REPLACE FUNCTION my_nls_territory_defaults(t VARCHAR2)
2 RETURN VARCHAR2 AS
3 s VARCHAR2(2048) := '';
4 BEGIN
5 EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TERRITORY = ''' || t || '''';
6 FOR i IN (SELECT * FROM nls_session_parameters WHERE parameter IN ('NLS_DATE_FORMAT', 'NLS_NUMERIC_CHARACTERS', 'NLS_CURRENCY', 'NLS_ISO_CURRENCY') ORDER BY parameter DESC)
7 LOOP
8 s := s || LPAD(i.parameter, 20) || '=' || RPAD(i.value, 20);
9 END LOOP;
10 RETURN s || ' 例: ' || TO_CHAR(TRUNC(SYSDATE, 'yy') - 1, 'ds');
11 END;
12* /
Function MY_NLS_TERRITORY_DEFAULTS compiled
SQL> SELECT RPAD(value, 20) || my_nls_territory_defaults(value) AS "NLS_TERRITORY_DEFAULT" FROM v$nls_valid_values WHERE parameter = 'TERRITORY' ORDER BY 1;
NLS_TERRITORY_DEFAULT
__________________________________________________________________________________________________________________________________________________________________________________________________________
AFGHANISTAN NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=AFGHANISTAN NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=؋ 例: 31/12/25
ALBANIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=ALBANIA NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=Lek 例: 31.12.2025
ALGERIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=ALGERIA NLS_DATE_FORMAT=DD-MM-RR NLS_CURRENCY=د.ج. 例: 31/12/2025
AMERICA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=AMERICA NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=$ 例: 12/31/2025
ARGENTINA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=ARGENTINA NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=$ 例: 31/12/2025
ARMENIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=ARMENIA NLS_DATE_FORMAT=DD.fmMM.RRRR NLS_CURRENCY=դր. 例: 31.12.2025
AUSTRALIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=AUSTRALIA NLS_DATE_FORMAT=DD/MON/RR NLS_CURRENCY=$ 例: 31/12/2025
AUSTRIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=AUSTRIA NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=€ 例: 31.12.2025
AZERBAIJAN NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=AZERBAIJAN NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=₼ 例: 31.12.2025
BAHAMAS NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=BAHAMAS NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=B$ 例: 31/12/2025
BAHRAIN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=BAHRAIN NLS_DATE_FORMAT=DD-MM-RR NLS_CURRENCY=د.ب. 例: 31/12/2025
BANGLADESH NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=BANGLADESH NLS_DATE_FORMAT=DD-MM-RRRR NLS_CURRENCY=৳ 例: 31-12-2025
BELARUS NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=BELARUS NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=р. 例: 31.12.2025
BELGIUM NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=BELGIUM NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=€ 例: 31/12/2025
BELIZE NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=BELIZE NLS_DATE_FORMAT=fmDD/MM/RRRR NLS_CURRENCY=BZ$ 例: 12/31/2025
BERMUDA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=BERMUDA NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=BD$ 例: 31/12/2025
BOLIVIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=BOLIVIA NLS_DATE_FORMAT=fmDD-MM-RR NLS_CURRENCY=B$ 例: 12-31-2025
BOSNIA AND HERZEGOVINLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=BOSNIA AND HERZEGOVI NLS_DATE_FORMAT=fmMM.DD.RRRR NLS_CURRENCY=КМ 例: 12.31.2025
BRAZIL NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=BRAZIL NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=R$ 例: 31/12/2025
BULGARIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=BULGARIA NLS_DATE_FORMAT=RRRR-MM-DD NLS_CURRENCY=лв 例: 31.12.2025
CAMBODIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=CAMBODIA NLS_DATE_FORMAT=RRRR-fmMM-DD NLS_CURRENCY=៛ 例: 2025-12-31
CAMEROON NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=CAMEROON NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=CFA 例: 31/12/25
CANADA NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=CANADA NLS_DATE_FORMAT=RR-MM-DD NLS_CURRENCY=$ 例: 2025-12-31
CATALONIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=CATALONIA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=€ 例: 31-12-16
CHILE NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=CHILE NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=$ 例: 31-12-2025
CHINA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=CHINA NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=￥ 例: 2025-12-31
CIS NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=CIS NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=р. 例: 31.12.16
COLOMBIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=COLOMBIA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=$ 例: 31/12/2025
CONGO BRAZZAVILLE NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=CONGO BRAZZAVILLE NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=CFA 例: 31/12/25
CONGO KINSHASA NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=CONGO KINSHASA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=FrCD 例: 31/12/25
COSTA RICA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=COSTA RICA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=C 例: 31/12/2025
CROATIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=CROATIA NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=kn 例: 31.12.16
CYPRUS NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=CYPRUS NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=£ 例: 31/12/2025
CZECH REPUBLIC NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=CZECH REPUBLIC NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=Kč 例: 31.12.2025
CZECHOSLOVAKIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=CZECHOSLOVAKIA NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=Kčs 例: 31.12.16
DENMARK NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=DENMARK NLS_DATE_FORMAT=RR-MM-DD NLS_CURRENCY=kr 例: 31-12-2025
DJIBOUTI NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=DJIBOUTI NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ف.ج. 例: 31/12/2025
ECUADOR NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=ECUADOR NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=$ 例: 31/12/2025
EGYPT NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=EGYPT NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ج.م. 例: 31/12/2025
EL SALVADOR NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=EL SALVADOR NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=C 例: 31/12/2025
ESTONIA NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=ESTONIA NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=kr 例: 31.12.2025
ETHIOPIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=ETHIOPIA NLS_DATE_FORMAT=fmDD/MM/RRRR NLS_CURRENCY=ብር 例: 12/31/2025
FINLAND NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=FINLAND NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=€ 例: 31.12.2025
FRANCE NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=FRANCE NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=€ 例: 31/12/2025
FYR MACEDONIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=FYR MACEDONIA NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=ден. 例: 31.12.2025
GABON NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=GABON NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=CFA 例: 31/12/25
GERMANY NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=GERMANY NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=€ 例: 31.12.2025
GREECE NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=GREECE NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=€ 例: 31/12/2025
GUATEMALA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=GUATEMALA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=Q 例: 31/12/2025
HONDURAS NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=HONDURAS NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=L 例: 31.12.2025
HONG KONG NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=HONG KONG NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=$ 例: 31/12/2025
HUNGARY NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=HUNGARY NLS_DATE_FORMAT=RR-MON-DD NLS_CURRENCY=Ft 例: 2025.12.31.
ICELAND NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=ICELAND NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=kr. 例: 31.12.2025
INDIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=INDIA NLS_DATE_FORMAT=DD-MM-RR NLS_CURRENCY=Rs 例: 31/12/2025
INDONESIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=INDONESIA NLS_DATE_FORMAT=DD-MM-RRRR NLS_CURRENCY=Rp 例: 31-12-2025
IRAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=IRAN NLS_DATE_FORMAT=RRRR/fmMM/fmDD NLS_CURRENCY=ريال 例: 2025/12/31
IRAQ NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=IRAQ NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=د.ع. 例: 31/12/2025
IRELAND NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=IRELAND NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=€ 例: 31/12/2025
ISRAEL NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=ISRAEL NLS_DATE_FORMAT=DD-MON-RRRR NLS_CURRENCY=ש"ח 例: 31/12/2025
ITALY NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=ITALY NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=€ 例: 31/12/2025
IVORY COAST NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=IVORY COAST NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=CFA 例: 31/12/25
JAPAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=JAPAN NLS_DATE_FORMAT=RR-MM-DD NLS_CURRENCY=¥ 例: 2025/12/31
JORDAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=JORDAN NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=د.ا. 例: 31/12/2025
KAZAKHSTAN NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=KAZAKHSTAN NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=KZT 例: 31.12.2025
KENYA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=KENYA NLS_DATE_FORMAT=fmMM/DD/RRRR NLS_CURRENCY=S 例: 12/31/2025
KOREA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=KOREA NLS_DATE_FORMAT=RR/MM/DD NLS_CURRENCY=￦ 例: 2025/12/31
KUWAIT NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=KUWAIT NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=د.ك. 例: 31/12/2025
LAOS NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=LAOS NLS_DATE_FORMAT=DD/fmMM/RRRR NLS_CURRENCY=₭ 例: 31/12/2025
LATVIA NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=LATVIA NLS_DATE_FORMAT=RRRR.MM.DD NLS_CURRENCY=Ls 例: 2025.12.31
LEBANON NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=LEBANON NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ل.ل. 例: 31/12/2025
LIBYA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=LIBYA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=د.ل. 例: 31/12/2025
LITHUANIA NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=LITHUANIA NLS_DATE_FORMAT=RRRR.MM.DD NLS_CURRENCY=€ 例: 2025-12-31
LUXEMBOURG NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=LUXEMBOURG NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=€ 例: 31.12.2025
MACEDONIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=MACEDONIA NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=den. 例: 31.12.2025
MALAYSIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=MALAYSIA NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=RM 例: 31/12/2025
MALDIVES NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=MALDIVES NLS_DATE_FORMAT=fmDD/fmMM/RR NLS_CURRENCY=ރ. 例: 12/31/25
MALTA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=MALTA NLS_DATE_FORMAT=fmDD/MM/RRRR NLS_CURRENCY=€ 例: 12/31/2025
MAURITANIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=MAURITANIA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ا.م. 例: 31/12/2025
MEXICO NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=MEXICO NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=$ 例: 31/12/2025
MONTENEGRO NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=MONTENEGRO NLS_DATE_FORMAT=DD.MM.RRRR. NLS_CURRENCY=€ 例: 31.12.2025.
MOROCCO NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=MOROCCO NLS_DATE_FORMAT=DD-MM-RR NLS_CURRENCY=د.م. 例: 31/12/2025
NEPAL NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=NEPAL NLS_DATE_FORMAT=fmDD/MM/RRRR NLS_CURRENCY=र 例: 12/31/2025
NEW ZEALAND NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=NEW ZEALAND NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=$ 例: 31/12/2025
NICARAGUA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=NICARAGUA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=C$ 例: 31/12/2025
NIGERIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=NIGERIA NLS_DATE_FORMAT=DD/fmMM/RRRR NLS_CURRENCY=₦ 例: 31/12/2025
NORWAY NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=NORWAY NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=kr 例: 31.12.2025
OMAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=OMAN NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ر.ع. 例: 31/12/2025
PAKISTAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=PAKISTAN NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=PKR 例: 31/12/2025
PANAMA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=PANAMA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=B/ 例: 12/31/2025
PARAGUAY NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=PARAGUAY NLS_DATE_FORMAT=fmDD/MM/RR NLS_CURRENCY=G 例: 12/31/25
PERU NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=PERU NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=S/ 例: 31/12/2025
PHILIPPINES NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=PHILIPPINES NLS_DATE_FORMAT=MM/DD/RRRR NLS_CURRENCY=Php 例: 12/31/2025
POLAND NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=POLAND NLS_DATE_FORMAT=RR/MM/DD NLS_CURRENCY=zł 例: 2025-12-31
PORTUGAL NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=PORTUGAL NLS_DATE_FORMAT=RR.MM.DD NLS_CURRENCY=€ 例: 31-12-2025
PUERTO RICO NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=PUERTO RICO NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=$ 例: 31/12/2025
QATAR NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=QATAR NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ر.ق. 例: 31/12/2025
ROMANIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=ROMANIA NLS_DATE_FORMAT=DD-MM-RRRR NLS_CURRENCY=LEI 例: 31.12.2025
RUSSIA NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=RUSSIA NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=₽ 例: 31.12.2025
SAUDI ARABIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SAUDI ARABIA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ر.س. 例: 31/12/2025
SENEGAL NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=SENEGAL NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=CFA 例: 31/12/2025
SERBIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=SERBIA NLS_DATE_FORMAT=DD.MM.RRRR. NLS_CURRENCY=RSD 例: 31.12.2025.
SERBIA AND MONTENEGRNLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=SERBIA AND MONTENEGR NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=din. 例: 31.12.2025
SINGAPORE NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SINGAPORE NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=S$ 例: 31/12/2025
SLOVAKIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=SLOVAKIA NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=Sk 例: 31.12.16
SLOVENIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=SLOVENIA NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=SIT 例: 31.12.16
SOMALIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SOMALIA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ش.ص. 例: 31/12/2025
SOUTH AFRICA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SOUTH AFRICA NLS_DATE_FORMAT=DD/MON/RR NLS_CURRENCY=R 例: 2025/12/31
SPAIN NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=SPAIN NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=€ 例: 31/12/2025
SRI LANKA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SRI LANKA NLS_DATE_FORMAT=RRRR/fmMM/fmDD NLS_CURRENCY=ريال 例: 2025/12/31
SUDAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SUDAN NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ج.س. 例: 31/12/2025
SWEDEN NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=SWEDEN NLS_DATE_FORMAT=RRRR-MM-DD NLS_CURRENCY=Kr 例: 2025-12-31
SWITZERLAND NLS_NUMERIC_CHARACTE=.' NLS_ISO_CURRENCY=SWITZERLAND NLS_DATE_FORMAT=DD.MM.RR NLS_CURRENCY=SFr. 例: 31.12.2025
SYRIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=SYRIA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ل.س. 例: 31/12/2025
TAIWAN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=TAIWAN NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=NT$ 例: 2025/12/31
TANZANIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=TANZANIA NLS_DATE_FORMAT=fmMM/DD/RRRR NLS_CURRENCY=TSh 例: 12/31/2025
THAILAND NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=THAILAND NLS_DATE_FORMAT=DD MON RRRR NLS_CURRENCY=฿ 例: 31/12/2025
THE NETHERLANDS NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=THE NETHERLANDS NLS_DATE_FORMAT=DD-MM-RR NLS_CURRENCY=€ 例: 31-12-2025
TUNISIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=TUNISIA NLS_DATE_FORMAT=DD-MM-RR NLS_CURRENCY=د.ت. 例: 31/12/2025
TURKEY NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=TURKEY NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=₺ 例: 31.12.2025
UGANDA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=UGANDA NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=CFA 例: 31/12/2025
UKRAINE NLS_NUMERIC_CHARACTE=, NLS_ISO_CURRENCY=UKRAINE NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=грн. 例: 31.12.2025
UNITED ARAB EMIRATESNLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=UNITED ARAB EMIRATES NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=د.إ. 例: 31/12/2025
UNITED KINGDOM NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=UNITED KINGDOM NLS_DATE_FORMAT=DD-MON-RR NLS_CURRENCY=£ 例: 31/12/2025
URUGUAY NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=URUGUAY NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=NU$ 例: 31/12/2025
UZBEKISTAN NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=UZBEKISTAN NLS_DATE_FORMAT=DD/MON/RR NLS_CURRENCY=UZS 例: 31/DEC/25
VENEZUELA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=VENEZUELA NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=Bs 例: 31/12/2025
VIETNAM NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=VIETNAM NLS_DATE_FORMAT=DD-MM-RRRR NLS_CURRENCY=₫ 例: 31-12-2025
YEMEN NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=YEMEN NLS_DATE_FORMAT=DD/MM/RR NLS_CURRENCY=ر.ي. 例: 31/12/2025
YUGOSLAVIA NLS_NUMERIC_CHARACTE=,. NLS_ISO_CURRENCY=YUGOSLAVIA NLS_DATE_FORMAT=DD.MM.RRRR NLS_CURRENCY=din. 例: 31.12.2025
ZAMBIA NLS_NUMERIC_CHARACTE=., NLS_ISO_CURRENCY=ZAMBIA NLS_DATE_FORMAT=DD/MM/RRRR NLS_CURRENCY=ZK 例: 31/12/2025
130 rows selected.
SQL> DROP FUNCTION my_nls_territory_defaults;
Function MY_NLS_TERRITORY_DEFAULTS dropped.結果が横長になってしまっていますが、例えばアメリカの場合は次のように日付フォーマットは「DD-MON-RR」という表記で、例としては「12/31/2025」のようになります。そして通貨記号は「$」、数字の桁区切り文字は「カンマ(,)」となっていて、小数点は「ドット(.)」です。
AMERICA
NLS_NUMERIC_CHARACTE=.,
NLS_ISO_CURRENCY=AMERICA
NLS_DATE_FORMAT=DD-MON-RR
NLS_CURRENCY=$
例: 12/31/2025そして日本の場合には、日付フォーマットは「RR-MM-DD」という表記で、例としては「2025/12/31」のようになります。そして通貨記号は「¥」、数字の桁区切り文字は「カンマ(,)」となっていて、小数点は「ドット(.)」です。
JAPAN
NLS_NUMERIC_CHARACTE=.,
NLS_ISO_CURRENCY=JAPAN
NLS_DATE_FORMAT=RR-MM-DD
NLS_CURRENCY=¥
例: 2025/12/31このようにして各国や地域毎に異なる日付フォーマット、通貨記号、数字の桁区切り文字などの表記を確認することが出来ます。
ある国や地域の設定に変更したい場合には、次のようなSQLを実行することで、当該国や地域の設定に変更することが可能です。ここではオーストラリアに設定しています。
ALTER SESSION SET NLS_TERRITORY = 'AUSTRALIA';言語毎の設定や日付表記を確認する方法
言語毎の設定や日付表記を確認するには、次のようなSQLを実行します。このSQLを実行することによって、データをソートする時の言語、言語毎の日付表記を確認することが出来ます。
CREATE OR REPLACE FUNCTION my_nls_language_defaults(t VARCHAR2)
RETURN VARCHAR2 AS
s VARCHAR2(2048) := '';
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE = ''' || t || '''';
FOR i IN (SELECT * FROM nls_session_parameters
WHERE parameter IN ('NLS_DATE_LANGUAGE','NLS_SORT') ORDER BY parameter DESC)
LOOP
s := s || LPAD(i.parameter, 20) || '=' || RPAD(i.value, 20);
END LOOP;
RETURN s || ' 例: ' || TO_CHAR(TRUNC(SYSDATE, 'yy') - 1, 'dl');
END;
/
SELECT RPAD(value, 20) || my_nls_language_defaults(value) AS "NLS_LANGUAGE_DEFAULT" FROM v$nls_valid_values WHERE parameter = 'LANGUAGE' ORDER BY 1;
DROP FUNCTION my_nls_language_defaults;このSQLを実行すると次のような結果が得られます。言語毎のソート順設定、日付のフォーマット例を表示しています。
SQL> CREATE OR REPLACE FUNCTION my_nls_language_defaults(t VARCHAR2)
2 RETURN VARCHAR2 AS
3 s VARCHAR2(2048) := '';
4 BEGIN
5 EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE = ''' || t || '''';
6 FOR i IN (SELECT * FROM nls_session_parameters WHERE parameter IN ('NLS_DATE_LANGUAGE','NLS_SORT') ORDER BY parameter DESC)
7 LOOP
8 s := s || LPAD(i.parameter, 20) || '=' || RPAD(i.value, 20);
9 END LOOP;
10 RETURN s || ' 例: ' || TO_CHAR(TRUNC(SYSDATE, 'yy') - 1, 'dl');
11 END;
12* /
Function MY_NLS_LANGUAGE_DEFAULTS compiled
SQL>
SQL> SELECT RPAD(value, 20) || my_nls_language_defaults(value) AS "NLS_LANGUAGE_DEFAULT" FROM v$nls_valid_values WHERE parameter = 'LANGUAGE' ORDER BY 1;
NLS_LANGUAGE_DEFAULT
____________________________________________________________________________________________________________________________________________
ALBANIAN NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=ALBANIAN 例: E Shtunë, Dhjetor 31, 2025
AMERICAN NLS_SORT=BINARY NLS_DATE_LANGUAGE=AMERICAN 例: Saturday, December 31, 2025
AMHARIC NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=AMHARIC 例: ቅዳሜ, ዲሴምበር 31, 2025
ARABIC NLS_SORT=ARABIC NLS_DATE_LANGUAGE=ARABIC 例: السبت, ديسمبر 31, 2025
ARMENIAN NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=ARMENIAN 例: Շաբա, Դեկտեմբեր 31, 2025
ASSAMESE NLS_SORT=BINARY NLS_DATE_LANGUAGE=ASSAMESE 例: শনিবাৰ, ডিচেম্বৰ 31, 2025
AZERBAIJANI NLS_SORT=AZERBAIJANI NLS_DATE_LANGUAGE=AZERBAIJANI 例: Şənbə, Dekabr 31, 2025
BANGLA NLS_SORT=BINARY NLS_DATE_LANGUAGE=BANGLA 例: শনিবার, ডিসেম্বর 31, 2025
BELARUSIAN NLS_SORT=RUSSIAN NLS_DATE_LANGUAGE=BELARUSIAN 例: Субота, Сьнежань 31, 2025
BENGALI NLS_SORT=BENGALI NLS_DATE_LANGUAGE=BENGALI 例: শনিবার, ডিসেমর 31, 2025
BRAZILIAN PORTUGUESE NLS_SORT=WEST_EUROPEAN NLS_DATE_LANGUAGE=BRAZILIAN PORTUGUESE 例: Sábado, Dezembro 31, 2025
BULGARIAN NLS_SORT=BULGARIAN NLS_DATE_LANGUAGE=BULGARIAN 例: Събота, Декември 31, 2025
CANADIAN FRENCH NLS_SORT=CANADIAN_M NLS_DATE_LANGUAGE=CANADIAN FRENCH 例: Samedi, Décembre 31, 2025
CATALAN NLS_SORT=CATALAN NLS_DATE_LANGUAGE=CATALAN 例: Dissabte, Desembre 31, 2025
CROATIAN NLS_SORT=CROATIAN NLS_DATE_LANGUAGE=CROATIAN 例: Subota, Prosinac 31, 2025
CYRILLIC KAZAKH NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=CYRILLIC KAZAKH 例: Сенбі, Желтоқсан 31, 2025
CYRILLIC SERBIAN NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=CYRILLIC SERBIAN 例: Субота, Децембар 31, 2025
CYRILLIC UZBEK NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=CYRILLIC UZBEK 例: Шанба, Декабр 31, 2025
CZECH NLS_SORT=CZECH NLS_DATE_LANGUAGE=CZECH 例: Sobota, Prosinec 31, 2025
DANISH NLS_SORT=DANISH NLS_DATE_LANGUAGE=DANISH 例: Lørdag, December 31, 2025
DARI NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=DARI 例: شنبه, دسمبر 31, 2025
DIVEHI NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=DIVEHI 例: ހޮނިހިރު, ޑިސެމްބަރ 31, 2025
DUTCH NLS_SORT=DUTCH NLS_DATE_LANGUAGE=DUTCH 例: Zaterdag, December 31, 2025
EGYPTIAN NLS_SORT=ARABIC NLS_DATE_LANGUAGE=EGYPTIAN 例: السبت, ديسمبر 31, 2025
ENGLISH NLS_SORT=BINARY NLS_DATE_LANGUAGE=ENGLISH 例: Saturday, December 31, 2025
ESTONIAN NLS_SORT=ESTONIAN NLS_DATE_LANGUAGE=ESTONIAN 例: Laupäev, Detsember 31, 2025
FINNISH NLS_SORT=FINNISH NLS_DATE_LANGUAGE=FINNISH 例: Lauantai, Joulukuu 31, 2025
FRENCH NLS_SORT=FRENCH NLS_DATE_LANGUAGE=FRENCH 例: Samedi, Décembre 31, 2025
GERMAN NLS_SORT=GERMAN NLS_DATE_LANGUAGE=GERMAN 例: Samstag, Dezember 31, 2025
GERMAN DIN NLS_SORT=GERMAN NLS_DATE_LANGUAGE=GERMAN DIN 例: Samstag, Dezember 31, 2025
GREEK NLS_SORT=GREEK NLS_DATE_LANGUAGE=GREEK 例: Σάββατο, Δεκέμβριος 31, 2025
GUJARATI NLS_SORT=BINARY NLS_DATE_LANGUAGE=GUJARATI 例: શનિવાર, ડિસેમ્બર 31, 2025
HEBREW NLS_SORT=HEBREW NLS_DATE_LANGUAGE=HEBREW 例: שבת, דצמבר 31, 2025
HINDI NLS_SORT=BINARY NLS_DATE_LANGUAGE=HINDI 例: शनिवार, दिसम्बर 31, 2025
HUNGARIAN NLS_SORT=HUNGARIAN NLS_DATE_LANGUAGE=HUNGARIAN 例: Szombat, December 31, 2025
ICELANDIC NLS_SORT=ICELANDIC NLS_DATE_LANGUAGE=ICELANDIC 例: Laugardagur, Desember 31, 2025
INDONESIAN NLS_SORT=INDONESIAN NLS_DATE_LANGUAGE=INDONESIAN 例: Sabtu, Desember 31, 2025
IRISH NLS_SORT=BINARY NLS_DATE_LANGUAGE=IRISH 例: Dé Sathairn, Nollaig 31, 2025
ITALIAN NLS_SORT=WEST_EUROPEAN NLS_DATE_LANGUAGE=ITALIAN 例: Sabato, Dicembre 31, 2025
JAPANESE NLS_SORT=BINARY NLS_DATE_LANGUAGE=JAPANESE 例: 土曜日, 12月 31, 2025
KANNADA NLS_SORT=BINARY NLS_DATE_LANGUAGE=KANNADA 例: ಶನಿವಾರ, ಡಿಸೆಂಬರ್ 31, 2025
KHMER NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=KHMER 例: ថ្ងៃសៅរ៍, ធ្នូ 31, 2025
KOREAN NLS_SORT=BINARY NLS_DATE_LANGUAGE=KOREAN 例: 토요일, 12월 31, 2025
LAO NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=LAO 例: ວັນເສົາ, ທັນວາ 31, 2025
LATIN AMERICAN SPANI NLS_SORT=SPANISH NLS_DATE_LANGUAGE=LATIN AMERICAN SPANI 例: Sábado, Diciembre 31, 2025
LATIN BOSNIAN NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=LATIN BOSNIAN 例: Subota, Decembar 31, 2025
LATIN SERBIAN NLS_SORT=BINARY NLS_DATE_LANGUAGE=LATIN SERBIAN 例: Subota, Decembar 31, 2025
LATIN UZBEK NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=LATIN UZBEK 例: Shanba, Dekabr 31, 2025
LATVIAN NLS_SORT=LATVIAN NLS_DATE_LANGUAGE=LATVIAN 例: Sestdiena, Decembris 31, 2025
LITHUANIAN NLS_SORT=LITHUANIAN NLS_DATE_LANGUAGE=LITHUANIAN 例: Šeštadienis, Gruodžio 31, 2025
MACEDONIAN NLS_SORT=BINARY NLS_DATE_LANGUAGE=MACEDONIAN 例: Сабота, Декември 31, 2025
MALAY NLS_SORT=MALAY NLS_DATE_LANGUAGE=MALAY 例: Sabtu, Disember 31, 2025
MALAYALAM NLS_SORT=BINARY NLS_DATE_LANGUAGE=MALAYALAM 例: ശനിആഴ്ച, ഡിസംബര് 31, 2025
MALTESE NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=MALTESE 例: Is-Sibt, Diċembru 31, 2025
MARATHI NLS_SORT=BINARY NLS_DATE_LANGUAGE=MARATHI 例: शनिवार, डिसेंबर 31, 2025
MEXICAN SPANISH NLS_SORT=WEST_EUROPEAN NLS_DATE_LANGUAGE=MEXICAN SPANISH 例: Sábado, Diciembre 31, 2025
NEPALI NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=NEPALI 例: शनिबार, डिसेम्बर 31, 2025
NORWEGIAN NLS_SORT=NORWEGIAN NLS_DATE_LANGUAGE=NORWEGIAN 例: Lørdag, Desember 31, 2025
ORIYA NLS_SORT=BINARY NLS_DATE_LANGUAGE=ORIYA 例: ଶନିବାର, ଡିସେମ୍ବର 31, 2025
PERSIAN NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=PERSIAN 例: شنبه, دسامبر 31, 2025
POLISH NLS_SORT=POLISH NLS_DATE_LANGUAGE=POLISH 例: Sobota, Grudzień 31, 2025
PORTUGUESE NLS_SORT=WEST_EUROPEAN NLS_DATE_LANGUAGE=PORTUGUESE 例: Sábado, Dezembro 31, 2025
PUNJABI NLS_SORT=BINARY NLS_DATE_LANGUAGE=PUNJABI 例: ਸ਼ਨਿਚੱਰਵਾਰ, ਦਸੰਬਰ 31, 2025
ROMANIAN NLS_SORT=ROMANIAN NLS_DATE_LANGUAGE=ROMANIAN 例: Sâmbătă, Decembrie 31, 2025
RUSSIAN NLS_SORT=RUSSIAN NLS_DATE_LANGUAGE=RUSSIAN 例: Суббота, Декабрь 31, 2025
SIMPLIFIED CHINESE NLS_SORT=BINARY NLS_DATE_LANGUAGE=SIMPLIFIED CHINESE 例: 星期六, 12月 31, 2025
SINHALA NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=SINHALA 例: සෙනසුරාදා, දෙසැම්බර් 31, 2025
SLOVAK NLS_SORT=SLOVAK NLS_DATE_LANGUAGE=SLOVAK 例: Sobota, December 31, 2025
SLOVENIAN NLS_SORT=SLOVENIAN NLS_DATE_LANGUAGE=SLOVENIAN 例: Sobota, December 31, 2025
SPANISH NLS_SORT=SPANISH NLS_DATE_LANGUAGE=SPANISH 例: Sábado, Diciembre 31, 2025
SWAHILI NLS_SORT=GENERIC_M NLS_DATE_LANGUAGE=SWAHILI 例: Jumamosi, Desemba 31, 2025
SWEDISH NLS_SORT=SWEDISH NLS_DATE_LANGUAGE=SWEDISH 例: Lördag, December 31, 2025
TAMIL NLS_SORT=BINARY NLS_DATE_LANGUAGE=TAMIL 例: சனிக்கிழமை, டிசம்பர் 31, 2025
TELUGU NLS_SORT=BINARY NLS_DATE_LANGUAGE=TELUGU 例: శనివారం, డిసెంబర్ 31, 2025
THAI NLS_SORT=THAI_DICTIONARY NLS_DATE_LANGUAGE=THAI 例: เสาร์, ธันวาคม 31, 2025
TRADITIONAL CHINESE NLS_SORT=BINARY NLS_DATE_LANGUAGE=TRADITIONAL CHINESE 例: 星期六, 12月 31, 2025
TURKISH NLS_SORT=TURKISH NLS_DATE_LANGUAGE=TURKISH 例: Cumartesi, Aralık 31, 2025
UKRAINIAN NLS_SORT=UKRAINIAN NLS_DATE_LANGUAGE=UKRAINIAN 例: Субота, Грудень 31, 2025
VIETNAMESE NLS_SORT=VIETNAMESE NLS_DATE_LANGUAGE=VIETNAMESE 例: Thứ Bảy, Tháng MườI Hai 31, 2025
79 rows selected.
SQL> DROP FUNCTION my_nls_language_defaults;
Function MY_NLS_LANGUAGE_DEFAULTS dropped.アメリカであれば、次のようにAMERICANという言語で、バイナリ順にソート、そして日付表記は「Saturday, December 31, 2025」のようになっています。
AMERICAN
NLS_SORT=BINARY
NLS_DATE_LANGUAGE=AMERICAN
例: Saturday, December 31, 2025日本の場合には、言語はJAPANESEで、データのソート順はバイナリとなっており、そして日付表記は「土曜日, 12月 31, 2025」のようになっています。
JAPANESE
NLS_SORT=BINARY
NLS_DATE_LANGUAGE=JAPANESE
例: 土曜日, 12月 31, 2025まとめ
ここまで見てきたように、Oracleデータベースの様々な国や地域毎の日付フォーマット、通貨記号、数字の区切り文字、そして言語毎のソート順や各言語による日付表記を取得する方法を紹介しました。国際化対応する場合にはとても重宝する情報かと思います。
