-- https://ja.wikipedia.org/wiki/ISO_3166-1 より 2017/05/12 現在
CREATE TABLE COUNTRIES
(
JAPANESE_NAME VARCHAR2(120) NOT NULL -- 国・地域名
, ENGLISH_NAME VARCHAR2(90) NOT NULL -- English short name (upper/lower case)
, NUMERIC_CODE NUMBER(3) NOT NULL -- Numeric code
, ALPHA_3 VARCHAR2(3) NOT NULL -- Alpha-3 code
, ALPHA_2 VARCHAR2(2) NOT NULL -- Alpha-2 code
, CONSTRAINT COUNTRIES_PK PRIMARY KEY(NUMERIC_CODE) USING INDEX
) ;
CREATE UNIQUE INDEX COUNTRIES_UI_JAPANESE_NAME ON COUNTRIES(JAPANESE_NAME)
CREATE UNIQUE INDEX COUNTRIES_UI_ENGLISH_NAME ON COUNTRIES(ENGLISH_NAME) ;
CREATE UNIQUE INDEX COUNTRIES_UI_ALPHA_3 ON COUNTRIES(ALPHA_3) ;
CREATE UNIQUE INDEX COUNTRIES_UI_ALPHA_2 ON COUNTRIES(ALPHA_2) ;
COMMENT ON TABLE COUNTRIES IS '国 https://ja.wikipedia.org/wiki/ISO_3166-1' ;
COMMENT ON COLUMN COUNTRIES.JAPANESE_NAME IS '国・地域名' ;
COMMENT ON COLUMN COUNTRIES.ENGLISH_NAME IS 'English short name (upper/lower case)' ;
COMMENT ON COLUMN COUNTRIES.NUMERIC_CODE IS 'Numeric code' ;
COMMENT ON COLUMN COUNTRIES.ALPHA_3 IS 'Alpha-3 code' ;
COMMENT ON COLUMN COUNTRIES.ALPHA_2 IS 'Alpha-2 code' ;
-- 以下、必要により
-- ↓ SELECT権をインスタンス内の全スキーマに与える
GRANT SELECT ON COUNTRIES TO PUBLIC ;
-- ↓ PUBLIC SYNONYM に
CREATE OR REPLACE PUBLIC SYNONYM COUNTRIES FOR COUNTRIES ;
INSERT
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フランス領南方・南極地域','French Southern Territories',260,'ATF','TF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アイスランド','Iceland',352,'ISL','IS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アイルランド','Ireland',372,'IRL','IE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アゼルバイジャン','Azerbaijan',31,'AZE','AZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アフガニスタン','Afghanistan',4,'AFG','AF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アメリカ合衆国','United States',840,'USA','US');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('合衆国領有小離島','United States Minor Outlying Islands',581,'UMI','UM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アメリカ領サモア','American Samoa',16,'ASM','AS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アメリカ領ヴァージン諸島','Virgin Islands, U.S.',850,'VIR','VI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アラブ首長国連邦','United Arab Emirates',784,'ARE','AE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アルジェリア','Algeria',12,'DZA','DZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アルゼンチン','Argentina',32,'ARG','AR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アルバ','Aruba',533,'ABW','AW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アルバニア','Albania',8,'ALB','AL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アルメニア','Armenia',51,'ARM','AM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アンギラ','Anguilla',660,'AIA','AI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アンゴラ','Angola',24,'AGO','AO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アンティグア・バーブーダ','Antigua and Barbuda',28,'ATG','AG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('アンドラ','Andorra',20,'AND','AD');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イエメン','Yemen',887,'YEM','YE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イギリス','United Kingdom',826,'GBR','GB');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イギリス領インド洋地域','British Indian Ocean Territory',86,'IOT','IO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イギリス領ヴァージン諸島','Virgin Islands, British',92,'VGB','VG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イスラエル','Israel',376,'ISR','IL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イタリア','Italy',380,'ITA','IT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イラク','Iraq',368,'IRQ','IQ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('イラン・イスラム共和国','Iran, Islamic Republic of',364,'IRN','IR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('インド','India',356,'IND','IN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('インドネシア','Indonesia',360,'IDN','ID');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ウォリス・フツナ','Wallis and Futuna',876,'WLF','WF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ウガンダ','Uganda',800,'UGA','UG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ウクライナ','Ukraine',804,'UKR','UA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ウズベキスタン','Uzbekistan',860,'UZB','UZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ウルグアイ','Uruguay',858,'URY','UY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('エクアドル','Ecuador',218,'ECU','EC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('エジプト','Egypt',818,'EGY','EG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('エストニア','Estonia',233,'EST','EE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('エチオピア','Ethiopia',231,'ETH','ET');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('エリトリア','Eritrea',232,'ERI','ER');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('エルサルバドル','El Salvador',222,'SLV','SV');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('オマーン','Oman',512,'OMN','OM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('オランダ','Netherlands',528,'NLD','NL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ボネール、シント・ユースタティウスおよびサバ','Bonaire, Saint Eustatius and Saba',535,'BES','BQ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('オーストラリア','Australia',36,'AUS','AU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ハード島とマクドナルド諸島','Heard Island and McDonald Islands',334,'HMD','HM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('オーストリア','Austria',40,'AUT','AT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('オーランド諸島','Åland Islands',248,'ALA','AX');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('カザフスタン','Kazakhstan',398,'KAZ','KZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('カタール','Qatar',634,'QAT','QA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('カナダ','Canada',124,'CAN','CA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('カメルーン','Cameroon',120,'CMR','CM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('カンボジア','Cambodia',116,'KHM','KH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('カーボベルデ','Cape Verde',132,'CPV','CV');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ガイアナ','Guyana',328,'GUY','GY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ガボン','Gabon',266,'GAB','GA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ガンビア','Gambia',270,'GMB','GM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ガーナ','Ghana',288,'GHA','GH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ガーンジー','Guernsey',831,'GGY','GG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('キプロス','Cyprus',196,'CYP','CY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('キュラソー','Curaçao',531,'CUW','CW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('キューバ','Cuba',192,'CUB','CU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('キリバス','Kiribati',296,'KIR','KI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('キルギス','Kyrgyzstan',417,'KGZ','KG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ギニア','Guinea',324,'GIN','GN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ギニアビサウ','Guinea-Bissau',624,'GNB','GW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ギリシャ','Greece',300,'GRC','GR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('クウェート','Kuwait',414,'KWT','KW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('クック諸島','Cook Islands',184,'COK','CK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('クリスマス島','Christmas Island',162,'CXR','CX');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('クロアチア','Croatia',191,'HRV','HR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('グアテマラ','Guatemala',320,'GTM','GT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('グアドループ','Guadeloupe',312,'GLP','GP');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('グアム','Guam',316,'GUM','GU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('グリーンランド','Greenland',304,'GRL','GL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('グレナダ','Grenada',308,'GRD','GD');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ケイマン諸島','Cayman Islands',136,'CYM','KY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ケニア','Kenya',404,'KEN','KE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ココス(キーリング)諸島','Cocos (Keeling) Islands',166,'CCK','CC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('コスタリカ','Costa Rica',188,'CRI','CR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('コモロ','Comoros',174,'COM','KM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('コロンビア','Colombia',170,'COL','CO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('コンゴ共和国','Congo',178,'COG','CG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('コンゴ民主共和国','Congo, the Democratic Republic of the',180,'COD','CD');
-- 文字列中の ' は2つ続ける
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('コートジボワール','Côte d''Ivoire',384,'CIV','CI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サウジアラビア','Saudi Arabia',682,'SAU','SA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サウスジョージア・サウスサンドウィッチ諸島','South Georgia and the South Sandwich Islands',239,'SGS','GS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サモア','Samoa',882,'WSM','WS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サントメ・プリンシペ','Sao Tome and Principe',678,'STP','ST');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サンピエール島・ミクロン島','Saint Pierre and Miquelon',666,'SPM','PM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サンマリノ','San Marino',674,'SMR','SM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サン・バルテルミー','Saint Barthélemy',652,'BLM','BL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ザンビア','Zambia',894,'ZMB','ZM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('シエラレオネ','Sierra Leone',694,'SLE','SL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('シリア・アラブ共和国','Syrian Arab Republic',760,'SYR','SY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('シンガポール','Singapore',702,'SGP','SG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('シント・マールテン(オランダ領)','Sint Maarten (Dutch part)',534,'SXM','SX');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ジブチ','Djibouti',262,'DJI','DJ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ジブラルタル','Gibraltar',292,'GIB','GI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ジャマイカ','Jamaica',388,'JAM','JM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ジャージー','Jersey',832,'JEY','JE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ジョージア','Georgia',268,'GEO','GE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ジンバブエ','Zimbabwe',716,'ZWE','ZW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スイス','Switzerland',756,'CHE','CH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スウェーデン','Sweden',752,'SWE','SE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スペイン','Spain',724,'ESP','ES');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スリナム','Suriname',740,'SUR','SR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スリランカ','Sri Lanka',144,'LKA','LK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スロバキア','Slovakia',703,'SVK','SK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スロベニア','Slovenia',705,'SVN','SI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スワジランド','Swaziland',748,'SWZ','SZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スーダン','Sudan',729,'SDN','SD');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セネガル','Senegal',686,'SEN','SN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セルビア','Serbia',688,'SRB','RS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セントクリストファー・ネイビス','Saint Kitts and Nevis',659,'KNA','KN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セントビンセントおよびグレナディーン諸島','Saint Vincent and the Grenadines',670,'VCT','VC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セントヘレナ・アセンションおよびトリスタンダクーニャ','Saint Helena, Ascension and Tristan da Cunha',654,'SHN','SH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セントルシア','Saint Lucia',662,'LCA','LC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('セーシェル','Seychelles',690,'SYC','SC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ソマリア','Somalia',706,'SOM','SO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ソロモン諸島','Solomon Islands',90,'SLB','SB');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('タイ','Thailand',764,'THA','TH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('タジキスタン','Tajikistan',762,'TJK','TJ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('タンザニア','Tanzania, United Republic of',834,'TZA','TZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('タークス・カイコス諸島','Turks and Caicos Islands',796,'TCA','TC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('チェコ','Czechia',203,'CZE','CZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('チャド','Chad',148,'TCD','TD');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('チュニジア','Tunisia',788,'TUN','TN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('チリ','Chile',152,'CHL','CL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ツバル','Tuvalu',798,'TUV','TV');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('デンマーク','Denmark',208,'DNK','DK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('トケラウ','Tokelau',772,'TKL','TK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('トリニダード・トバゴ','Trinidad and Tobago',780,'TTO','TT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('トルクメニスタン','Turkmenistan',795,'TKM','TM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('トルコ','Turkey',792,'TUR','TR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('トンガ','Tonga',776,'TON','TO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('トーゴ','Togo',768,'TGO','TG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ドイツ','Germany',276,'DEU','DE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ドミニカ共和国','Dominican Republic',214,'DOM','DO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ドミニカ国','Dominica',212,'DMA','DM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ナイジェリア','Nigeria',566,'NGA','NG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ナウル','Nauru',520,'NRU','NR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ナミビア','Namibia',516,'NAM','NA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ニウエ','Niue',570,'NIU','NU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ニカラグア','Nicaragua',558,'NIC','NI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ニジェール','Niger',562,'NER','NE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ニューカレドニア','New Caledonia',540,'NCL','NC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ニュージーランド','New Zealand',554,'NZL','NZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ネパール','Nepal',524,'NPL','NP');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('スヴァールバル諸島およびヤンマイエン島','Svalbard and Jan Mayen',744,'SJM','SJ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ノルウェー','Norway',578,'NOR','NO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブーベ島','Bouvet Island',74,'BVT','BV');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ノーフォーク島','Norfolk Island',574,'NFK','NF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ハイチ','Haiti',332,'HTI','HT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ハンガリー','Hungary',348,'HUN','HU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バチカン市国','Holy See (Vatican City State)',336,'VAT','VA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バヌアツ','Vanuatu',548,'VUT','VU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バハマ','Bahamas',44,'BHS','BS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バミューダ','Bermuda',60,'BMU','BM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バルバドス','Barbados',52,'BRB','BB');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バングラデシュ','Bangladesh',50,'BGD','BD');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('バーレーン','Bahrain',48,'BHR','BH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('パキスタン','Pakistan',586,'PAK','PK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('パナマ','Panama',591,'PAN','PA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('パプアニューギニア','Papua New Guinea',598,'PNG','PG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('パラオ','Palau',585,'PLW','PW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('パラグアイ','Paraguay',600,'PRY','PY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('パレスチナ','Palestinian Territory, Occupied',275,'PSE','PS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ピトケアン','Pitcairn',612,'PCN','PN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フィジー','Fiji',242,'FJI','FJ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フィリピン','Philippines',608,'PHL','PH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フィンランド','Finland',246,'FIN','FI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フェロー諸島','Faroe Islands',234,'FRO','FO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フォークランド(マルビナス)諸島','Falkland Islands (Malvinas)',238,'FLK','FK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('サン・マルタン(フランス領)','Saint Martin (French part)',663,'MAF','MF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フランス','France',250,'FRA','FR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マヨット','Mayotte',175,'MYT','YT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フランス領ギアナ','French Guiana',254,'GUF','GF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('フランス領ポリネシア','French Polynesia',258,'PYF','PF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブラジル','Brazil',76,'BRA','BR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブルガリア','Bulgaria',100,'BGR','BG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブルキナファソ','Burkina Faso',854,'BFA','BF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブルネイ・ダルサラーム','Brunei Darussalam',96,'BRN','BN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブルンジ','Burundi',108,'BDI','BI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ブータン','Bhutan',64,'BTN','BT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('プエルトリコ','Puerto Rico',630,'PRI','PR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ベトナム','Viet Nam',704,'VNM','VN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ベナン','Benin',204,'BEN','BJ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ベネズエラ・ボリバル共和国','Venezuela, Bolivarian Republic of',862,'VEN','VE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ベラルーシ','Belarus',112,'BLR','BY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ベリーズ','Belize',84,'BLZ','BZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ベルギー','Belgium',56,'BEL','BE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ペルー','Peru',604,'PER','PE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ホンジュラス','Honduras',340,'HND','HN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ボスニア・ヘルツェゴビナ','Bosnia and Herzegovina',70,'BIH','BA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ボツワナ','Botswana',72,'BWA','BW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ボリビア多民族国','Bolivia, Plurinational State of',68,'BOL','BO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ポルトガル','Portugal',620,'PRT','PT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ポーランド','Poland',616,'POL','PL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マカオ','Macau',446,'MAC','MO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マケドニア旧ユーゴスラビア共和国','Macedonia, the former Yugoslav Republic of',807,'MKD','MK');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マダガスカル','Madagascar',450,'MDG','MG');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マラウイ','Malawi',454,'MWI','MW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マリ','Mali',466,'MLI','ML');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マルタ','Malta',470,'MLT','MT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マルティニーク','Martinique',474,'MTQ','MQ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マレーシア','Malaysia',458,'MYS','MY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マン島','Isle of Man',833,'IMN','IM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('マーシャル諸島','Marshall Islands',584,'MHL','MH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ミクロネシア連邦','Micronesia, Federated States of',583,'FSM','FM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ミャンマー','Myanmar',104,'MMR','MM');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('メキシコ','Mexico',484,'MEX','MX');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モザンビーク','Mozambique',508,'MOZ','MZ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モナコ','Monaco',492,'MCO','MC');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モルディブ','Maldives',462,'MDV','MV');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モルドバ共和国','Moldova, Republic of',498,'MDA','MD');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モロッコ','Morocco',504,'MAR','MA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モンゴル','Mongolia',496,'MNG','MN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モンテネグロ','Montenegro',499,'MNE','ME');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モントセラト','Montserrat',500,'MSR','MS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モーリシャス','Mauritius',480,'MUS','MU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('モーリタニア','Mauritania',478,'MRT','MR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ヨルダン','Jordan',400,'JOR','JO');
-- 文字列中の ' は2つ続ける
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ラオス人民民主共和国','Lao People''s Democratic Republic',418,'LAO','LA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ラトビア','Latvia',428,'LVA','LV');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('リトアニア','Lithuania',440,'LTU','LT');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('リヒテンシュタイン','Liechtenstein',438,'LIE','LI');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('リビア','Libya',434,'LBY','LY');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('リベリア','Liberia',430,'LBR','LR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ルクセンブルク','Luxembourg',442,'LUX','LU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ルワンダ','Rwanda',646,'RWA','RW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ルーマニア','Romania',642,'ROU','RO');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('レソト','Lesotho',426,'LSO','LS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('レバノン','Lebanon',422,'LBN','LB');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('レユニオン','Réunion',638,'REU','RE');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('ロシア連邦','Russian Federation',643,'RUS','RU');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('中央アフリカ共和国','Central African Republic',140,'CAF','CF');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('中華人民共和国','China',156,'CHN','CN');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('台湾','Taiwan, Province of China',158,'TWN','TW');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('北マリアナ諸島','Northern Mariana Islands',580,'MNP','MP');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('南アフリカ','South Africa',710,'ZAF','ZA');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('南スーダン','South Sudan',728,'SSD','SS');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('南極','Antarctica',10,'ATA','AQ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('大韓民国','Korea, Republic of',410,'KOR','KR');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('日本','Japan',392,'JPN','JP');
-- 文字列中の ' は2つ続ける
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('朝鮮民主主義人民共和国','Korea, Democratic People''s Republic of',408,'PRK','KP');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('東ティモール','Timor-Leste',626,'TLS','TL');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('西サハラ','Western Sahara',732,'ESH','EH');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('赤道ギニア','Equatorial Guinea',226,'GNQ','GQ');
INSERT INTO COUNTRIES(JAPANESE_NAME, ENGLISH_NAME, NUMERIC_CODE, Alpha_3, Alpha_2) VALUES('香港','Hong Kong',344,'HKG','HK');
COMMIT ;