CREATE TABLE CURRENCIES
(
CURRENCY_CODE VARCHAR2(3) NOT NULL -- 通貨コード
, CURRENCY_NAME VARCHAR2(90) NOT NULL -- 通貨名
, COUNTRY_NAME VARCHAR2(120) NOT NULL -- 国名
, REMARKS VARCHAR2(120) -- 備考
, CONSTRAINT CURRENCIES_PK PRIMARY KEY(CURRENCY_CODE) USING INDEX
) ;
-- ↓UNIQUE INDEX にはできない
CREATE INDEX CURRENCIES_IX_CURRENCY_NAME ON CURRENCIES(CURRENCY_NAME) ;
COMMENT ON TABLE CURRENCIES IS '通貨 https://ja.wikipedia.org/wiki/ISO_4217' ;
COMMENT ON COLUMN CURRENCIES.CURRENCY_CODE IS '通貨コード' ;
COMMENT ON COLUMN CURRENCIES.CURRENCY_NAME IS '通貨名' ;
COMMENT ON COLUMN CURRENCIES.COUNTRY_NAME IS '国名' ;
COMMENT ON COLUMN CURRENCIES.REMARKS IS '備考' ;
-- 以下、必要により
-- ↓ SELECT権をインスタンス内の全スキーマに与える
GRANT SELECT ON CURRENCIES TO PUBLIC ;
-- ↓ PUBLIC SYNONYM に
CREATE OR REPLACE PUBLIC SYNONYM CURRENCIES FOR CURRENCIES ;
INSERT
SET LINESIZE 200
SET PAGESIZE 200
SPOOL currencies.log
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AED','UAEディルハム','アラブ首長国連邦','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AFN','アフガニ','アフガニスタン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ALL','レク','アルバニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AMD','ドラム','アルメニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ANG','アンティル・ギルダー','キュラソー、シント・マールテン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AOA','クワンザ','アンゴラ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ARS','アルゼンチン・ペソ','アルゼンチン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AUD','オーストラリア・ドル','オーストラリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AWG','アルバ・フロリン','アルバ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('AZN','アゼルバイジャン・マナト','アゼルバイジャン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BAM','兌換マルク','ボスニア・ヘルツェゴビナ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BBD','バルバドス・ドル','バルバドス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BDT','タカ','バングラデシュ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BGN','レフ','ブルガリア','1999年7月5日以降(以前はBGL)') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BHD','バーレーン・ディナール','バーレーン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BIF','ブルンジ・フラン','ブルンジ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BMD','バミューダ・ドル','バミューダ諸島','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BND','ブルネイ・ドル','ブルネイ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BOB','ボリビアーノ','ボリビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BRL','レアル','ブラジル','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BSD','バハマ・ドル','バハマ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BTN','ニュルタム','ブータン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BWP','プラ','ボツワナ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BYN','ベラルーシ・ルーブル','ベラルーシ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('BZD','ベリーズ・ドル','ベリーズ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CAD','カナダ・ドル','カナダ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CDF','コンゴ・フラン','コンゴ民主共和国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CHF','スイス・フラン','スイス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CLP','チリ・ペソ','チリ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CNY','人民元','中華人民共和国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('COP','コロンビア・ペソ','コロンビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CRC','コスタリカ・コロン','コスタリカ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CUC','兌換ペソ','キューバ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CUP','キューバ・ペソ','キューバ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CVE','カーボベルデ・エスクード','カーボベルデ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('CZK','チェコ・コルナ','チェコ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('DJF','ジブチ・フラン','ジブチ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('DKK','デンマーク・クローネ','デンマーク','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('DOP','ドミニカ・ペソ','ドミニカ共和国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('DZD','アルジェリア・ディナール','アルジェリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('EGP','エジプト・ポンド','エジプト','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ERN','ナクファ','エリトリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ETB','ブル','エチオピア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('EUR','ユーロ','欧州連合(EU)','2015年2月現在、EU加盟国以外も含め25ヵ国で使用') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('FJD','フィジー・ドル','フィジー','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('FKP','フォークランド諸島・ポンド','フォークランド諸島','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GBP','UKポンド','イギリス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GEL','ラリ','ジョージア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GGP','ガーンジー・ポンド','ガーンジー島','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GHS','セディ','ガーナ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GIP','ジブラルタル・ポンド','ジブラルタル','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GMD','ダラシ','ガンビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GNF','ギニア・フラン','ギニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GTQ','ケツァル','グアテマラ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('GYD','ガイアナ・ドル','ガイアナ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('HKD','香港ドル','香港','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('HNL','レンピラ','ホンジュラス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('HRK','クーナ','クロアチア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('HTG','グールド','ハイチ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('HUF','フォリント','ハンガリー','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('IDR','ルピア','インドネシア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ILS','新シェケル','イスラエル','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('INR','インド・ルピー','インド','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('IQD','イラク・ディナール','イラク','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('IRR','イラン・リヤル','イラン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ISK','アイスランド・クローナ','アイスランド','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('JMD','ジャマイカ・ドル','ジャマイカ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('JOD','ヨルダン・ディナール','ヨルダン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('JPY','円','日本','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KES','ケニア・シリング','ケニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KGS','キルギス・ソム','キルギス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KHR','リエル','カンボジア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KMF','コモロ・フラン','コモロ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KPW','ウォン','朝鮮民主主義人民共和国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KRW','ウォン','大韓民国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KWD','クウェート・ディナール','クウェート','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KYD','ケイマン諸島・ドル','ケイマン諸島','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('KZT','テンゲ','カザフスタン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('LAK','キープ','ラオス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('LBP','レバノン・ポンド','レバノン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('LKR','スリランカ・ルピー','スリランカ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('LRD','リベリア・ドル','リベリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('LSL','ロチ','レソト','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('LYD','リビア・ディナール','リビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MAD','モロッコ・ディルハム','モロッコ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MDL','モルドバ・レウ','モルドバ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MGA','アリアリ','マダガスカル','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MKD','マケドニア・デナール','マケドニア共和国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MMK','チャット','ミャンマー','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MNT','トゥグルグ','モンゴル国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MOP','パタカ','マカオ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MRO','ウギア','モーリタニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MUR','モーリシャス・ルピー','モーリシャス','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MVR','ルフィヤ','モルディブ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MWK','マラウイ・クワチャ','マラウイ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MXN','メキシコ・ペソ','メキシコ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MYR','リンギット','マレーシア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('MZN','メティカル','モザンビーク','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('NAD','ナミビア・ドル','ナミビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('NGN','ナイラ','ナイジェリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('NIO','ニカラグア・コルドバ','ニカラグア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('NOK','ノルウェー・クローネ','ノルウェー','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('NPR','ネパール・ルピー','ネパール','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('NZD','ニュージーランド・ドル','ニュージーランド','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('OMR','オマーン・リアル','オマーン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PAB','バルボア','パナマ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PEN','ヌエボ・ソル','ペルー','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PGK','キナ','パプアニューギニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PHP','フィリピン・ペソ','フィリピン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PKR','パキスタン・ルピー','パキスタン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PLN','ズウォティ','ポーランド','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('PYG','グアラニー','パラグアイ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('QAR','カタール・リヤル','カタール','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('RON','新ルーマニア・レウ','ルーマニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('RSD','セルビア・ディナール','セルビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('RUB','ロシア・ルーブル','ロシア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('RWF','ルワンダ・フラン','ルワンダ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SAR','サウジアラビア・リヤル','サウジアラビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SBD','ソロモン諸島ドル','ソロモン諸島','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SCR','セーシェル・ルピー','セーシェル','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SDG','スーダン・ポンド','スーダン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SEK','スウェーデン・クローナ','スウェーデン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SGD','シンガポール・ドル','シンガポール','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SHP','セントヘレナ・ポンド','セントヘレナ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SLL','レオン','シエラレオネ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SOS','ソマリア・シリング','ソマリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SRD','スリナム・ドル','スリナム','2004年1月1日から使用') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SSP','南スーダン・ポンド','南スーダン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('STD','ドブラ','サントメ・プリンシペ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SVC','サルバドール・コロン','エルサルバドル','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SYP','シリア・ポンド','シリア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('SZL','リランゲニ','スワジランド','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('THB','バーツ','タイ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TJS','ソモニ','タジキスタン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TMT','トルクメニスタン・マナト','トルクメニスタン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TND','チュニジア・ディナール','チュニジア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TOP','パアンガ','トンガ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TRY','新トルコリラ','トルコ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TTD','トリニダード・トバゴ・ドル','トリニダード・トバゴ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TWD','ニュー台湾ドル','中華民国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('TZS','タンザニア・シリング','タンザニア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('UAH','フリヴニャ','ウクライナ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('UGX','ウガンダ・シリング','ウガンダ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('USD','アメリカ合衆国ドル','アメリカ合衆国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('UYU','ウルグアイ・ペソ','ウルグアイ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('UZS','スム','ウズベキスタン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('VEF','ボリバル','ベネズエラ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('VND','ドン','ベトナム','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('VUV','バツ','バヌアツ','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('WST','タラ','サモア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XAF','CFAフラン','中部アフリカ諸国','中部アフリカ諸国銀行 (BEAC) が発行') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XAG','銀','(なし)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XAU','金','(なし)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XCD','東カリブ・ドル','カリブ海諸国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XDR','特別引出権','(なし)','国際通貨基金') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XOF','CFAフラン','西アフリカ諸国','西アフリカ諸国中央銀行 (BCEAO) が発行') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XPD','パラジウム','(なし)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XPF','CFPフラン','フランス海外領土(太平洋)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XPT','白金','(なし)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XTS','テスト用コード','(なし)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('XXX','通貨なし','(なし)','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('YER','イエメン・リアル','イエメン','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ZAR','ランド','南アフリカ共和国','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ZMW','ザンビア・クワチャ','ザンビア','') ;
INSERT INTO CURRENCIES(CURRENCY_CODE, CURRENCY_NAME, COUNTRY_NAME, REMARKS) VALUES('ZWL','ジンバブエ・ドル','ジンバブエ','') ;
COMMIT ;
SPOOL OFF