Example Country Table

From TekiWiki
Jump to: navigation, search

Oracle Database example table for use in various pages in TekiWiki:

create table iso_country (
code varchar2(2) not null primary key
,name varchar2(200) not null
);

insert into iso_country values ('AF','AFGHANISTAN');
insert into iso_country values ('AX','ÅLAND ISLANDS');
insert into iso_country values ('AL','ALBANIA');
insert into iso_country values ('DZ','ALGERIA');
insert into iso_country values ('AS','AMERICAN SAMOA');
insert into iso_country values ('AD','ANDORRA');
insert into iso_country values ('AO','ANGOLA');
insert into iso_country values ('AI','ANGUILLA');
insert into iso_country values ('AQ','ANTARCTICA');
insert into iso_country values ('AG','ANTIGUA AND BARBUDA');
insert into iso_country values ('AR','ARGENTINA');
insert into iso_country values ('AM','ARMENIA');
insert into iso_country values ('AW','ARUBA');
insert into iso_country values ('AU','AUSTRALIA');
insert into iso_country values ('AT','AUSTRIA');
insert into iso_country values ('AZ','AZERBAIJAN');
insert into iso_country values ('BS','BAHAMAS');
insert into iso_country values ('BH','BAHRAIN');
insert into iso_country values ('BD','BANGLADESH');
insert into iso_country values ('BB','BARBADOS');
insert into iso_country values ('BY','BELARUS');
insert into iso_country values ('BE','BELGIUM');
insert into iso_country values ('BZ','BELIZE');
insert into iso_country values ('BJ','BENIN');
insert into iso_country values ('BM','BERMUDA');
insert into iso_country values ('BT','BHUTAN');
insert into iso_country values ('BO','BOLIVIA, PLURINATIONAL STATE OF');
insert into iso_country values ('BQ','BONAIRE, SINT EUSTATIUS AND SABA');
insert into iso_country values ('BA','BOSNIA AND HERZEGOVINA');
insert into iso_country values ('BW','BOTSWANA');
insert into iso_country values ('BV','BOUVET ISLAND');
insert into iso_country values ('BR','BRAZIL');
insert into iso_country values ('IO','BRITISH INDIAN OCEAN TERRITORY');
insert into iso_country values ('BN','BRUNEI DARUSSALAM');
insert into iso_country values ('BG','BULGARIA');
insert into iso_country values ('BF','BURKINA FASO');
insert into iso_country values ('BI','BURUNDI');
insert into iso_country values ('KH','CAMBODIA');
insert into iso_country values ('CM','CAMEROON');
insert into iso_country values ('CA','CANADA');
insert into iso_country values ('CV','CAPE VERDE');
insert into iso_country values ('KY','CAYMAN ISLANDS');
insert into iso_country values ('CF','CENTRAL AFRICAN REPUBLIC');
insert into iso_country values ('TD','CHAD');
insert into iso_country values ('CL','CHILE');
insert into iso_country values ('CN','CHINA');
insert into iso_country values ('CX','CHRISTMAS ISLAND');
insert into iso_country values ('CC','COCOS (KEELING) ISLANDS');
insert into iso_country values ('CO','COLOMBIA');
insert into iso_country values ('KM','COMOROS');
insert into iso_country values ('CG','CONGO');
insert into iso_country values ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE');
insert into iso_country values ('CK','COOK ISLANDS');
insert into iso_country values ('CR','COSTA RICA');
insert into iso_country values ('CI','CÔTE D''IVOIRE');
insert into iso_country values ('HR','CROATIA');
insert into iso_country values ('CU','CUBA');
insert into iso_country values ('CW','CURAÇAO');
insert into iso_country values ('CY','CYPRUS');
insert into iso_country values ('CZ','CZECH REPUBLIC');
insert into iso_country values ('DK','DENMARK');
insert into iso_country values ('DJ','DJIBOUTI');
insert into iso_country values ('DM','DOMINICA');
insert into iso_country values ('DO','DOMINICAN REPUBLIC');
insert into iso_country values ('EC','ECUADOR');
insert into iso_country values ('EG','EGYPT');
insert into iso_country values ('SV','EL SALVADOR');
insert into iso_country values ('GQ','EQUATORIAL GUINEA');
insert into iso_country values ('ER','ERITREA');
insert into iso_country values ('EE','ESTONIA');
insert into iso_country values ('ET','ETHIOPIA');
insert into iso_country values ('FK','FALKLAND ISLANDS (MALVINAS)');
insert into iso_country values ('FO','FAROE ISLANDS');
insert into iso_country values ('FJ','FIJI');
insert into iso_country values ('FI','FINLAND');
insert into iso_country values ('FR','FRANCE');
insert into iso_country values ('GF','FRENCH GUIANA');
insert into iso_country values ('PF','FRENCH POLYNESIA');
insert into iso_country values ('TF','FRENCH SOUTHERN TERRITORIES');
insert into iso_country values ('GA','GABON');
insert into iso_country values ('GM','GAMBIA');
insert into iso_country values ('GE','GEORGIA');
insert into iso_country values ('DE','GERMANY');
insert into iso_country values ('GH','GHANA');
insert into iso_country values ('GI','GIBRALTAR');
insert into iso_country values ('GR','GREECE');
insert into iso_country values ('GL','GREENLAND');
insert into iso_country values ('GD','GRENADA');
insert into iso_country values ('GP','GUADELOUPE');
insert into iso_country values ('GU','GUAM');
insert into iso_country values ('GT','GUATEMALA');
insert into iso_country values ('GG','GUERNSEY');
insert into iso_country values ('GN','GUINEA');
insert into iso_country values ('GW','GUINEA-BISSAU');
insert into iso_country values ('GY','GUYANA');
insert into iso_country values ('HT','HAITI');
insert into iso_country values ('HM','HEARD ISLAND AND MCDONALD ISLANDS');
insert into iso_country values ('VA','HOLY SEE (VATICAN CITY STATE)');
insert into iso_country values ('HN','HONDURAS');
insert into iso_country values ('HK','HONG KONG');
insert into iso_country values ('HU','HUNGARY');
insert into iso_country values ('IS','ICELAND');
insert into iso_country values ('IN','INDIA');
insert into iso_country values ('ID','INDONESIA');
insert into iso_country values ('IR','IRAN, ISLAMIC REPUBLIC OF');
insert into iso_country values ('IQ','IRAQ');
insert into iso_country values ('IE','IRELAND');
insert into iso_country values ('IM','ISLE OF MAN');
insert into iso_country values ('IL','ISRAEL');
insert into iso_country values ('IT','ITALY');
insert into iso_country values ('JM','JAMAICA');
insert into iso_country values ('JP','JAPAN');
insert into iso_country values ('JE','JERSEY');
insert into iso_country values ('JO','JORDAN');
insert into iso_country values ('KZ','KAZAKHSTAN');
insert into iso_country values ('KE','KENYA');
insert into iso_country values ('KI','KIRIBATI');
insert into iso_country values ('KP','KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF');
insert into iso_country values ('KR','KOREA, REPUBLIC OF');
insert into iso_country values ('KW','KUWAIT');
insert into iso_country values ('KG','KYRGYZSTAN');
insert into iso_country values ('LA','LAO PEOPLE''S DEMOCRATIC REPUBLIC');
insert into iso_country values ('LV','LATVIA');
insert into iso_country values ('LB','LEBANON');
insert into iso_country values ('LS','LESOTHO');
insert into iso_country values ('LR','LIBERIA');
insert into iso_country values ('LY','LIBYAN ARAB JAMAHIRIYA');
insert into iso_country values ('LI','LIECHTENSTEIN');
insert into iso_country values ('LT','LITHUANIA');
insert into iso_country values ('LU','LUXEMBOURG');
insert into iso_country values ('MO','MACAO');
insert into iso_country values ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF');
insert into iso_country values ('MG','MADAGASCAR');
insert into iso_country values ('MW','MALAWI');
insert into iso_country values ('MY','MALAYSIA');
insert into iso_country values ('MV','MALDIVES');
insert into iso_country values ('ML','MALI');
insert into iso_country values ('MT','MALTA');
insert into iso_country values ('MH','MARSHALL ISLANDS');
insert into iso_country values ('MQ','MARTINIQUE');
insert into iso_country values ('MR','MAURITANIA');
insert into iso_country values ('MU','MAURITIUS');
insert into iso_country values ('YT','MAYOTTE');
insert into iso_country values ('MX','MEXICO');
insert into iso_country values ('FM','MICRONESIA, FEDERATED STATES OF');
insert into iso_country values ('MD','MOLDOVA, REPUBLIC OF');
insert into iso_country values ('MC','MONACO');
insert into iso_country values ('MN','MONGOLIA');
insert into iso_country values ('ME','MONTENEGRO');
insert into iso_country values ('MS','MONTSERRAT');
insert into iso_country values ('MA','MOROCCO');
insert into iso_country values ('MZ','MOZAMBIQUE');
insert into iso_country values ('MM','MYANMAR');
insert into iso_country values ('NA','NAMIBIA');
insert into iso_country values ('NR','NAURU');
insert into iso_country values ('NP','NEPAL');
insert into iso_country values ('NL','NETHERLANDS');
insert into iso_country values ('NC','NEW CALEDONIA');
insert into iso_country values ('NZ','NEW ZEALAND');
insert into iso_country values ('NI','NICARAGUA');
insert into iso_country values ('NE','NIGER');
insert into iso_country values ('NG','NIGERIA');
insert into iso_country values ('NU','NIUE');
insert into iso_country values ('NF','NORFOLK ISLAND');
insert into iso_country values ('MP','NORTHERN MARIANA ISLANDS');
insert into iso_country values ('NO','NORWAY');
insert into iso_country values ('OM','OMAN');
insert into iso_country values ('PK','PAKISTAN');
insert into iso_country values ('PW','PALAU');
insert into iso_country values ('PS','PALESTINIAN TERRITORY, OCCUPIED');
insert into iso_country values ('PA','PANAMA');
insert into iso_country values ('PG','PAPUA NEW GUINEA');
insert into iso_country values ('PY','PARAGUAY');
insert into iso_country values ('PE','PERU');
insert into iso_country values ('PH','PHILIPPINES');
insert into iso_country values ('PN','PITCAIRN');
insert into iso_country values ('PL','POLAND');
insert into iso_country values ('PT','PORTUGAL');
insert into iso_country values ('PR','PUERTO RICO');
insert into iso_country values ('QA','QATAR');
insert into iso_country values ('RE','RÉUNION');
insert into iso_country values ('RO','ROMANIA');
insert into iso_country values ('RU','RUSSIAN FEDERATION');
insert into iso_country values ('RW','RWANDA');
insert into iso_country values ('BL','SAINT BARTHÉLEMY');
insert into iso_country values ('SH','SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA');
insert into iso_country values ('KN','SAINT KITTS AND NEVIS');
insert into iso_country values ('LC','SAINT LUCIA');
insert into iso_country values ('MF','SAINT MARTIN (FRENCH PART)');
insert into iso_country values ('PM','SAINT PIERRE AND MIQUELON');
insert into iso_country values ('VC','SAINT VINCENT AND THE GRENADINES');
insert into iso_country values ('WS','SAMOA');
insert into iso_country values ('SM','SAN MARINO');
insert into iso_country values ('ST','SAO TOME AND PRINCIPE');
insert into iso_country values ('SA','SAUDI ARABIA');
insert into iso_country values ('SN','SENEGAL');
insert into iso_country values ('RS','SERBIA');
insert into iso_country values ('SC','SEYCHELLES');
insert into iso_country values ('SL','SIERRA LEONE');
insert into iso_country values ('SG','SINGAPORE');
insert into iso_country values ('SX','SINT MAARTEN (DUTCH PART)');
insert into iso_country values ('SK','SLOVAKIA');
insert into iso_country values ('SI','SLOVENIA');
insert into iso_country values ('SB','SOLOMON ISLANDS');
insert into iso_country values ('SO','SOMALIA');
insert into iso_country values ('ZA','SOUTH AFRICA');
insert into iso_country values ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS');
insert into iso_country values ('SS','SOUTH SUDAN');
insert into iso_country values ('ES','SPAIN');
insert into iso_country values ('LK','SRI LANKA');
insert into iso_country values ('SD','SUDAN');
insert into iso_country values ('SR','SURINAME');
insert into iso_country values ('SJ','SVALBARD AND JAN MAYEN');
insert into iso_country values ('SZ','SWAZILAND');
insert into iso_country values ('SE','SWEDEN');
insert into iso_country values ('CH','SWITZERLAND');
insert into iso_country values ('SY','SYRIAN ARAB REPUBLIC');
insert into iso_country values ('TW','TAIWAN, PROVINCE OF CHINA');
insert into iso_country values ('TJ','TAJIKISTAN');
insert into iso_country values ('TZ','TANZANIA, UNITED REPUBLIC OF');
insert into iso_country values ('TH','THAILAND');
insert into iso_country values ('TL','TIMOR-LESTE');
insert into iso_country values ('TG','TOGO');
insert into iso_country values ('TK','TOKELAU');
insert into iso_country values ('TO','TONGA');
insert into iso_country values ('TT','TRINIDAD AND TOBAGO');
insert into iso_country values ('TN','TUNISIA');
insert into iso_country values ('TR','TURKEY');
insert into iso_country values ('TM','TURKMENISTAN');
insert into iso_country values ('TC','TURKS AND CAICOS ISLANDS');
insert into iso_country values ('TV','TUVALU');
insert into iso_country values ('UG','UGANDA');
insert into iso_country values ('UA','UKRAINE');
insert into iso_country values ('AE','UNITED ARAB EMIRATES');
insert into iso_country values ('GB','UNITED KINGDOM');
insert into iso_country values ('US','UNITED STATES');
insert into iso_country values ('UM','UNITED STATES MINOR OUTLYING ISLANDS');
insert into iso_country values ('UY','URUGUAY');
insert into iso_country values ('UZ','UZBEKISTAN');
insert into iso_country values ('VU','VANUATU');
insert into iso_country values ('VE','VENEZUELA, BOLIVARIAN REPUBLIC OF');
insert into iso_country values ('VN','VIET NAM');
insert into iso_country values ('VG','VIRGIN ISLANDS, BRITISH');
insert into iso_country values ('VI','VIRGIN ISLANDS, U.S.');
insert into iso_country values ('WF','WALLIS AND FUTUNA');
insert into iso_country values ('EH','WESTERN SAHARA');
insert into iso_country values ('YE','YEMEN');
insert into iso_country values ('ZM','ZAMBIA');
insert into iso_country values ('ZW','ZIMBABWE');