ISO Country List (SQL Insert)

ISO Country List (SQL Insert).md

SQL: ISO Country List

SQL Insert in English and Portuguese

See the files iso_country_list_insert.sql and iso_country_list_insert_pt-br.sql, respectively. Copy your content and paste it in your DBMS. Runs and make the commit.

iso_country_list_insert.sql

-- Creates the table
CREATE TABLE COUNTRY (
  CD_ISO VARCHAR2(2) NOT NULL PRIMARY KEY,
  NM_COUNTRY VARCHAR2(80) NOT NULL,
  NM_PRINTABLE VARCHAR2(80) NOT NULL,
  CD_ISO3 VARCHAR2(3),
  CD_COUNTRY NUMBER
);

-- Or
CREATE TABLE IF NOT EXISTS COUNTRY (
  CD_ISO CHAR(2) NOT NULL PRIMARY KEY,
  NM_COUNTRY VARCHAR(80) NOT NULL,
  NM_PRINTABLE VARCHAR(80) NOT NULL,
  CD_ISO3 CHAR(3),
  CD_COUNTRY SMALLINT
);

-- Makes the inserts
INSERT INTO COUNTRY VALUES ('AF','AFGHANISTAN','Afghanistan','AFG','004');
INSERT INTO COUNTRY VALUES ('AL','ALBANIA','Albania','ALB','008');
INSERT INTO COUNTRY VALUES ('DZ','ALGERIA','Algeria','DZA','012');
INSERT INTO COUNTRY VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');
INSERT INTO COUNTRY VALUES ('AD','ANDORRA','Andorra','AND','020');
INSERT INTO COUNTRY VALUES ('AO','ANGOLA','Angola','AGO','024');
INSERT INTO COUNTRY VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO COUNTRY VALUES ('AQ','ANTARCTICA','Antarctica',NULL,NULL);
INSERT INTO COUNTRY VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');
INSERT INTO COUNTRY VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO COUNTRY VALUES ('AM','ARMENIA','Armenia','ARM','051');
INSERT INTO COUNTRY VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO COUNTRY VALUES ('AU','AUSTRALIA','Australia','AUS','036');
INSERT INTO COUNTRY VALUES ('AT','AUSTRIA','Austria','AUT','040');
INSERT INTO COUNTRY VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');
INSERT INTO COUNTRY VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO COUNTRY VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO COUNTRY VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO COUNTRY VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO COUNTRY VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO COUNTRY VALUES ('BE','BELGIUM','Belgium','BEL','056');
INSERT INTO COUNTRY VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO COUNTRY VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO COUNTRY VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO COUNTRY VALUES ('BT','BHUTAN','Bhutan','BTN','064');
INSERT INTO COUNTRY VALUES ('BO','BOLIVIA','Bolivia','BOL','068');
INSERT INTO COUNTRY VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');
INSERT INTO COUNTRY VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO COUNTRY VALUES ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL);
INSERT INTO COUNTRY VALUES ('BR','BRAZIL','Brazil','BRA','076');
INSERT INTO COUNTRY VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL);
INSERT INTO COUNTRY VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO COUNTRY VALUES ('BG','BULGARIA','Bulgaria','BGR','100');
INSERT INTO COUNTRY VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO COUNTRY VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO COUNTRY VALUES ('KH','CAMBODIA','Cambodia','KHM','116');
INSERT INTO COUNTRY VALUES ('CM','CAMEROON','Cameroon','CMR','120');
INSERT INTO COUNTRY VALUES ('CA','CANADA','Canada','CAN','124');
INSERT INTO COUNTRY VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');
INSERT INTO COUNTRY VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');
INSERT INTO COUNTRY VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');
INSERT INTO COUNTRY VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO COUNTRY VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO COUNTRY VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO COUNTRY VALUES ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL);
INSERT INTO COUNTRY VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('CO','COLOMBIA','Colombia','COL','170');
INSERT INTO COUNTRY VALUES ('KM','COMOROS','Comoros','COM','174');
INSERT INTO COUNTRY VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO COUNTRY VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');
INSERT INTO COUNTRY VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');
INSERT INTO COUNTRY VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO COUNTRY VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');
INSERT INTO COUNTRY VALUES ('HR','CROATIA','Croatia','HRV','191');
INSERT INTO COUNTRY VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO COUNTRY VALUES ('CY','CYPRUS','Cyprus','CYP','196');
INSERT INTO COUNTRY VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');
INSERT INTO COUNTRY VALUES ('DK','DENMARK','Denmark','DNK','208');
INSERT INTO COUNTRY VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO COUNTRY VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO COUNTRY VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');
INSERT INTO COUNTRY VALUES ('EC','ECUADOR','Ecuador','ECU','218');
INSERT INTO COUNTRY VALUES ('EG','EGYPT','Egypt','EGY','818');
INSERT INTO COUNTRY VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO COUNTRY VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');
INSERT INTO COUNTRY VALUES ('ER','ERITREA','Eritrea','ERI','232');
INSERT INTO COUNTRY VALUES ('EE','ESTONIA','Estonia','EST','233');
INSERT INTO COUNTRY VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');
INSERT INTO COUNTRY VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO COUNTRY VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');
INSERT INTO COUNTRY VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO COUNTRY VALUES ('FI','FINLAND','Finland','FIN','246');
INSERT INTO COUNTRY VALUES ('FR','FRANCE','France','FRA','250');
INSERT INTO COUNTRY VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');
INSERT INTO COUNTRY VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');
INSERT INTO COUNTRY VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL);
INSERT INTO COUNTRY VALUES ('GA','GABON','Gabon','GAB','266');
INSERT INTO COUNTRY VALUES ('GM','GAMBIA','Gambia','GMB','270');
INSERT INTO COUNTRY VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO COUNTRY VALUES ('DE','GERMANY','Germany','DEU','276');
INSERT INTO COUNTRY VALUES ('GH','GHANA','Ghana','GHA','288');
INSERT INTO COUNTRY VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO COUNTRY VALUES ('GR','GREECE','Greece','GRC','300');
INSERT INTO COUNTRY VALUES ('GL','GREENLAND','Greenland','GRL','304');
INSERT INTO COUNTRY VALUES ('GD','GRENADA','Grenada','GRD','308');
INSERT INTO COUNTRY VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');
INSERT INTO COUNTRY VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO COUNTRY VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO COUNTRY VALUES ('GN','GUINEA','Guinea','GIN','324');
INSERT INTO COUNTRY VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');
INSERT INTO COUNTRY VALUES ('GY','GUYANA','Guyana','GUY','328');
INSERT INTO COUNTRY VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO COUNTRY VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');
INSERT INTO COUNTRY VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO COUNTRY VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO COUNTRY VALUES ('HU','HUNGARY','Hungary','HUN','348');
INSERT INTO COUNTRY VALUES ('IS','ICELAND','Iceland','ISL','352');
INSERT INTO COUNTRY VALUES ('IN','INDIA','India','IND','356');
INSERT INTO COUNTRY VALUES ('ID','INDONESIA','Indonesia','IDN','360');
INSERT INTO COUNTRY VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');
INSERT INTO COUNTRY VALUES ('IQ','IRAQ','Iraq','IRQ','368');
INSERT INTO COUNTRY VALUES ('IE','IRELAND','Ireland','IRL','372');
INSERT INTO COUNTRY VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO COUNTRY VALUES ('IT','ITALY','Italy','ITA','380');
INSERT INTO COUNTRY VALUES ('JM','JAMAICA','Jamaica','JAM','388');
INSERT INTO COUNTRY VALUES ('JP','JAPAN','Japan','JPN','392');
INSERT INTO COUNTRY VALUES ('JO','JORDAN','Jordan','JOR','400');
INSERT INTO COUNTRY VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');
INSERT INTO COUNTRY VALUES ('KE','KENYA','Kenya','KEN','404');
INSERT INTO COUNTRY VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO COUNTRY VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');
INSERT INTO COUNTRY VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');
INSERT INTO COUNTRY VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO COUNTRY VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');
INSERT INTO COUNTRY VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');
INSERT INTO COUNTRY VALUES ('LV','LATVIA','Latvia','LVA','428');
INSERT INTO COUNTRY VALUES ('LB','LEBANON','Lebanon','LBN','422');
INSERT INTO COUNTRY VALUES ('LS','LESOTHO','Lesotho','LSO','426');
INSERT INTO COUNTRY VALUES ('LR','LIBERIA','Liberia','LBR','430');
INSERT INTO COUNTRY VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO COUNTRY VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO COUNTRY VALUES ('LT','LITHUANIA','Lithuania','LTU','440');
INSERT INTO COUNTRY VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');
INSERT INTO COUNTRY VALUES ('MO','MACAO','Macao','MAC','446');
INSERT INTO COUNTRY VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO COUNTRY VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO COUNTRY VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO COUNTRY VALUES ('MY','MALAYSIA','Malaysia','MYS','458');
INSERT INTO COUNTRY VALUES ('MV','MALDIVES','Maldives','MDV','462');
INSERT INTO COUNTRY VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO COUNTRY VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO COUNTRY VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');
INSERT INTO COUNTRY VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO COUNTRY VALUES ('MR','MAURITANIA','Mauritania','MRT','478');
INSERT INTO COUNTRY VALUES ('MU','MAURITIUS','Mauritius','MUS','480');
INSERT INTO COUNTRY VALUES ('YT','MAYOTTE','Mayotte',NULL,NULL);
INSERT INTO COUNTRY VALUES ('MX','MEXICO','Mexico','MEX','484');
INSERT INTO COUNTRY VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO COUNTRY VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');
INSERT INTO COUNTRY VALUES ('MC','MONACO','Monaco','MCO','492');
INSERT INTO COUNTRY VALUES ('MN','MONGOLIA','Mongolia','MNG','496');
INSERT INTO COUNTRY VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO COUNTRY VALUES ('MA','MOROCCO','Morocco','MAR','504');
INSERT INTO COUNTRY VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');
INSERT INTO COUNTRY VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO COUNTRY VALUES ('NA','NAMIBIA','Namibia','NAM','516');
INSERT INTO COUNTRY VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO COUNTRY VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO COUNTRY VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');
INSERT INTO COUNTRY VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');
INSERT INTO COUNTRY VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO COUNTRY VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');
INSERT INTO COUNTRY VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');
INSERT INTO COUNTRY VALUES ('NE','NIGER','Niger','NER','562');
INSERT INTO COUNTRY VALUES ('NG','NIGERIA','Nigeria','NGA','566');
INSERT INTO COUNTRY VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO COUNTRY VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');
INSERT INTO COUNTRY VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');
INSERT INTO COUNTRY VALUES ('NO','NORWAY','Norway','NOR','578');
INSERT INTO COUNTRY VALUES ('OM','OMAN','Oman','OMN','512');
INSERT INTO COUNTRY VALUES ('PK','PAKISTAN','Pakistan','PAK','586');
INSERT INTO COUNTRY VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO COUNTRY VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL);
INSERT INTO COUNTRY VALUES ('PA','PANAMA','Panama','PAN','591');
INSERT INTO COUNTRY VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');
INSERT INTO COUNTRY VALUES ('PY','PARAGUAY','Paraguay','PRY','600');
INSERT INTO COUNTRY VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO COUNTRY VALUES ('PH','PHILIPPINES','Philippines','PHL','608');
INSERT INTO COUNTRY VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO COUNTRY VALUES ('PL','POLAND','Poland','POL','616');
INSERT INTO COUNTRY VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO COUNTRY VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');
INSERT INTO COUNTRY VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO COUNTRY VALUES ('RE','REUNION','Reunion','REU','638');
INSERT INTO COUNTRY VALUES ('RO','ROMANIA','Romania','ROM','642');
INSERT INTO COUNTRY VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');
INSERT INTO COUNTRY VALUES ('RW','RWANDA','Rwanda','RWA','646');
INSERT INTO COUNTRY VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');
INSERT INTO COUNTRY VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');
INSERT INTO COUNTRY VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');
INSERT INTO COUNTRY VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');
INSERT INTO COUNTRY VALUES ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO COUNTRY VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO COUNTRY VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO COUNTRY VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');
INSERT INTO COUNTRY VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');
INSERT INTO COUNTRY VALUES ('SN','SENEGAL','Senegal','SEN','686');
INSERT INTO COUNTRY VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL);
INSERT INTO COUNTRY VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO COUNTRY VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');
INSERT INTO COUNTRY VALUES ('SG','SINGAPORE','Singapore','SGP','702');
INSERT INTO COUNTRY VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');
INSERT INTO COUNTRY VALUES ('SI','SLOVENIA','Slovenia','SVN','705');
INSERT INTO COUNTRY VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');
INSERT INTO COUNTRY VALUES ('SO','SOMALIA','Somalia','SOM','706');
INSERT INTO COUNTRY VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');
INSERT INTO COUNTRY VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('ES','SPAIN','Spain','ESP','724');
INSERT INTO COUNTRY VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO COUNTRY VALUES ('SD','SUDAN','Sudan','SDN','736');
INSERT INTO COUNTRY VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO COUNTRY VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');
INSERT INTO COUNTRY VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');
INSERT INTO COUNTRY VALUES ('SE','SWEDEN','Sweden','SWE','752');
INSERT INTO COUNTRY VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');
INSERT INTO COUNTRY VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');
INSERT INTO COUNTRY VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');
INSERT INTO COUNTRY VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');
INSERT INTO COUNTRY VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO COUNTRY VALUES ('TH','THAILAND','Thailand','THA','764');
INSERT INTO COUNTRY VALUES ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL);
INSERT INTO COUNTRY VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO COUNTRY VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO COUNTRY VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO COUNTRY VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');
INSERT INTO COUNTRY VALUES ('TN','TUNISIA','Tunisia','TUN','788');
INSERT INTO COUNTRY VALUES ('TR','TURKEY','Turkey','TUR','792');
INSERT INTO COUNTRY VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');
INSERT INTO COUNTRY VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');
INSERT INTO COUNTRY VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO COUNTRY VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO COUNTRY VALUES ('UA','UKRAINE','Ukraine','UKR','804');
INSERT INTO COUNTRY VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');
INSERT INTO COUNTRY VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');
INSERT INTO COUNTRY VALUES ('US','UNITED STATES','United States','USA','840');
INSERT INTO COUNTRY VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL);
INSERT INTO COUNTRY VALUES ('UY','URUGUAY','Uruguay','URY','858');
INSERT INTO COUNTRY VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');
INSERT INTO COUNTRY VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO COUNTRY VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO COUNTRY VALUES ('VN','VIET NAM','Viet Nam','VNM','704');
INSERT INTO COUNTRY VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');
INSERT INTO COUNTRY VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');
INSERT INTO COUNTRY VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');
INSERT INTO COUNTRY VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');
INSERT INTO COUNTRY VALUES ('YE','YEMEN','Yemen','YEM','887');
INSERT INTO COUNTRY VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');
INSERT INTO COUNTRY VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');

iso_country_list_insert_pt-br.sq

-- Cria a tabela
CREATE TABLE PAIS (
  CD_ISO VARCHAR2(2) NOT NULL PRIMARY KEY,
  NM_PAIS VARCHAR2(80) NOT NULL,
  NM_PRINTABLE VARCHAR2(80) NOT NULL,
  CD_ISO3 VARCHAR2(3),
  CD_PAIS NUMBER
);

-- Ou
CREATE TABLE IF NOT EXISTS PAIS (
  CD_ISO CHAR(2) NOT NULL PRIMARY KEY,
  NM_PAIS VARCHAR(80) NOT NULL,
  NM_PRINTABLE VARCHAR(80) NOT NULL,
  CD_ISO3 CHAR(3),
  CD_PAIS SMALLINT
);

-- Faz os inserts
INSERT INTO PAIS VALUES ('AF','AFEGANISTÃO','Afeganistão','AFG','004');
INSERT INTO PAIS VALUES ('AL','ALBÂNIA','Albânia','ALB','008');
INSERT INTO PAIS VALUES ('DZ','ARGÉLIA','Argélia','DZA','012');
INSERT INTO PAIS VALUES ('AS','SAMOA AMERICANA','Samoa Americana','ASM','016');
INSERT INTO PAIS VALUES ('AD','ANDORRA','Andorra','E','020');
INSERT INTO PAIS VALUES ('AO','ANGOLA','Angola','Ago','024');
INSERT INTO PAIS VALUES ('AI','ANGUILLA','Anguilla','AIA','660');
INSERT INTO PAIS VALUES ('AQ','ANTÁRTICA','Antarctica', NULL, NULL);
INSERT INTO PAIS VALUES ('AG','ANTÍGUA E BARBUDA','Antígua e Barbuda','ATG','028');
INSERT INTO PAIS VALUES ('AR','ARGENTINA','Argentina','ARG','032');
INSERT INTO PAIS VALUES ('AM','ARMÊNIA','Armênia','ARM','051');
INSERT INTO PAIS VALUES ('AW','ARUBA','Aruba','ABW','533');
INSERT INTO PAIS VALUES ('AU','AUSTRÁLIA','Austrália','AUS','036');
INSERT INTO PAIS VALUES ('AT','ÁUSTRIA','Áustria','AUT','040');
INSERT INTO PAIS VALUES ('AZ','AZERBAIJÃO','Azerbaijão','AZE','031');
INSERT INTO PAIS VALUES ('BS','BAHAMAS','Bahamas','BHS','044');
INSERT INTO PAIS VALUES ('BH','BAHRAIN','Bahrain','BHR','048');
INSERT INTO PAIS VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');
INSERT INTO PAIS VALUES ('BB','BARBADOS','Barbados','BRB','052');
INSERT INTO PAIS VALUES ('BY','BELARUS','Belarus','BLR','112');
INSERT INTO PAIS VALUES ('BE','BÉLGICA','Bélgica','BEL','056');
INSERT INTO PAIS VALUES ('BZ','BELIZE','Belize','BLZ','084');
INSERT INTO PAIS VALUES ('BJ','BENIN','Benin','BEN','204');
INSERT INTO PAIS VALUES ('BM','BERMUDA','Bermuda','BMU','060');
INSERT INTO PAIS VALUES ('BT','BHUTAN','Butão','BTN','064');
INSERT INTO PAIS VALUES ('BO','BOLÍVIA','Bolívia','BOL','068');
INSERT INTO PAIS VALUES ('BA','BÓSNIA E HERZEGOVINA','Bósnia e Herzegovina','BIH','070');
INSERT INTO PAIS VALUES ('BW','BOTSWANA','Botswana','BWA','072');
INSERT INTO PAIS VALUES ('BV','ILHA BOUVET','Ilha Bouvet', NULL, NULL);
INSERT INTO PAIS VALUES ('BR','BRASIL','Brasil','BRA','076');
INSERT INTO PAIS VALUES ('IO','TERRITÓRIO BRITÂNICO DO OCEÂNO ÍNDICO','Território Britânico do Oceano Índico', NULL, NULL);
INSERT INTO PAIS VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');
INSERT INTO PAIS VALUES ('BG','BULGÁRIA','Bulgária','BGR','100');
INSERT INTO PAIS VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');
INSERT INTO PAIS VALUES ('BI','BURUNDI','Burundi','BDI','108');
INSERT INTO PAIS VALUES ('KH','CAMBOJA','Cambodia','KHM','116');
INSERT INTO PAIS VALUES ('CM','CAMARÕES','Camarões','CMR','120');
INSERT INTO PAIS VALUES ('CA','CANADÁ','Canadá','CAN','124');
INSERT INTO PAIS VALUES ('CV','CABO VERDE','Cabo Verde','CPV','132');
INSERT INTO PAIS VALUES ('KY','ILHAS CAYMAN','Ilhas Cayman','CYM','136');
INSERT INTO PAIS VALUES ('CF','CENTRAL AFRICANO REPÚBLICA','Central Africano República','CAF','140');
INSERT INTO PAIS VALUES ('TD','CHAD','Chad','TCD','148');
INSERT INTO PAIS VALUES ('CL','CHILE','Chile','CHL','152');
INSERT INTO PAIS VALUES ('CN','CHINA','China','CHN','156');
INSERT INTO PAIS VALUES ('CX','ILHA CHRISTMAS','Ilha Christmas', NULL, NULL);
INSERT INTO PAIS VALUES ('CC','ILHAS COCOS (KEELING)','Cocos (Keeling)', NULL, NULL);
INSERT INTO PAIS VALUES ('CO','COLÔMBIA','Colômbia','COL','170');
INSERT INTO PAIS VALUES ('KM','COMORES','Comores','COM','174');
INSERT INTO PAIS VALUES ('CG','CONGO','Congo','COG','178');
INSERT INTO PAIS VALUES ('CD','CONGO, REPÚBLICA DEMOCRÁTICA DO','Congo, República Democrática do','COD','180');
INSERT INTO PAIS VALUES ('CK','ILHAS COOK','Ilhas Cook','COK','184');
INSERT INTO PAIS VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');
INSERT INTO PAIS VALUES ('CI','COSTA DO MARFIM','Costa do Marfim','CIV','384');
INSERT INTO PAIS VALUES ('HR','CROÁCIA','Croácia','VFC','191');
INSERT INTO PAIS VALUES ('CU','CUBA','Cuba','CUB','192');
INSERT INTO PAIS VALUES ('CY','CHIPRE','Chipre','CYP','196');
INSERT INTO PAIS VALUES ('CZ','REPÚBLICA CHECA','República Checa','CZE','203');
INSERT INTO PAIS VALUES ('DK','DINAMARCA','Dinamarca','DNK','208');
INSERT INTO PAIS VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');
INSERT INTO PAIS VALUES ('DM','DOMINICA','Dominica','DMA','212');
INSERT INTO PAIS VALUES ('DO','REPÚBLICA DOMINICANA','República Dominicana','DOM ​​','214');
INSERT INTO PAIS VALUES ('EC','EQUADOR','Equador','ECU','218');
INSERT INTO PAIS VALUES ('EG','EGITO','Egito','EGY','818');
INSERT INTO PAIS VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');
INSERT INTO PAIS VALUES ('GQ','GUINÉ EQUATORIAL','Guiné Equatorial','QNG','226');
INSERT INTO PAIS VALUES ('ER','ERITREA','Eritreia','IIE','232');
INSERT INTO PAIS VALUES ('EE','ESTÔNIA','Estónia','EST','233');
INSERT INTO PAIS VALUES ('ET','ETIÓPIA','Ethiopia','ETH','231');
INSERT INTO PAIS VALUES ('FK','ILHAS FALKLAND (MALVINAS)','Ilhas Falkland (Malvinas)','FLK','238');
INSERT INTO PAIS VALUES ('FO','ILHAS FAROÉ','Ilhas Faroé','FRO','234');
INSERT INTO PAIS VALUES ('FJ','FIJI','Fiji','FJI','242');
INSERT INTO PAIS VALUES ('FI','FINLÂNDIA','Finlândia','FIN','246');
INSERT INTO PAIS VALUES ('FR','FRANÇA','França','FRA','250');
INSERT INTO PAIS VALUES ('GF','GUIANA FRANCESA','Guiana Francesa','GUF','254');
INSERT INTO PAIS VALUES ('PF','POLINÉSIA','Polinésia Francesa','PYF','258');
INSERT INTO PAIS VALUES ('TF','TERRITÓRIOS FRANCESES DO SUL','Territórios Franceses do Sul', null, null);
INSERT INTO PAIS VALUES ('GA','GABÃO','Gabão','GAB','266');
INSERT INTO PAIS VALUES ('GM','GÂMBIA','Gâmbia','GMB','270');
INSERT INTO PAIS VALUES ('GE','GEORGIA','Georgia','GEO','268');
INSERT INTO PAIS VALUES ('DE','ALEMANHA','Alemanha','DEU','276');
INSERT INTO PAIS VALUES ('GH','GANA','Ghana','GHA','288');
INSERT INTO PAIS VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');
INSERT INTO PAIS VALUES ('GR','GRÉCIA','Grécia','GRC','300');
INSERT INTO PAIS VALUES ('GL','GRONELÂNDIA','Gronelândia','GRL','304');
INSERT INTO PAIS VALUES ('GD','GRANADA','Granada','GRD','308');
INSERT INTO PAIS VALUES ('GP','GUADALUPE','Guadalupe','GLP','312');
INSERT INTO PAIS VALUES ('GU','GUAM','Guam','GUM','316');
INSERT INTO PAIS VALUES ('GT','GUATEMALA','Guatemala','GTM','320');
INSERT INTO PAIS VALUES ('GN','GUINÉ','Guiné','GIN','324');
INSERT INTO PAIS VALUES ('GW','GUINÉ-BISSAU','Guiné-Bissau','GNB','624');
INSERT INTO PAIS VALUES ('GY','GUIANA','Guyana','GUY','328');
INSERT INTO PAIS VALUES ('HT','HAITI','Haiti','HTI','332');
INSERT INTO PAIS VALUES ('HM','ILHAS HEARD E MCDONALD','Ilhas Heard e McDonald', NULL, NULL);
INSERT INTO PAIS VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Santa Sé (Cidade do Vaticano)','IVA','336');
INSERT INTO PAIS VALUES ('HN','HONDURAS','Honduras','HND','340');
INSERT INTO PAIS VALUES ('HK','HONG KONG','Hong Kong','HKG','344');
INSERT INTO PAIS VALUES ('HU','HUNGRIA','Hungria','HUN','348');
INSERT INTO PAIS VALUES ('IS','ISLÂNDIA','Islândia','ISL','352');
INSERT INTO PAIS VALUES ('IN','ÍNDIA','Índia','IND','356');
INSERT INTO PAIS VALUES ('ID','INDONÉSIA','Indonésia','IDN','360');
INSERT INTO PAIS VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Irã, República Islâmica do','IRN','364');
INSERT INTO PAIS VALUES ('IQ','IRAQUE','Iraque','IRQ','368');
INSERT INTO PAIS VALUES ('IE','IRLANDA','Irlanda','IRL','372');
INSERT INTO PAIS VALUES ('IL','ISRAEL','Israel','ISR','376');
INSERT INTO PAIS VALUES ('IT','ITÁLIA','Itália','ITA','380');
INSERT INTO PAIS VALUES ('JM','JAMAICA','Jamaica','Jam','388');
INSERT INTO PAIS VALUES ('JP','JAPÃO','Japão','JPN','392');
INSERT INTO PAIS VALUES ('JO','JORDÂNIA','Jordânia','JOR','400');
INSERT INTO PAIS VALUES ('KZ','CAZAQUISTÃO','Cazaquistão','KAZ','398');
INSERT INTO PAIS VALUES ('KE','QUÊNIA','Quênia','KEN','404');
INSERT INTO PAIS VALUES ('KI','KIRIBATI','Kiribati','KIR','296');
INSERT INTO PAIS VALUES ('KP','CORÉIA, REPÚBLICA POPULAR DEMOCRÁTICA DA','Coréia, República Popular Democrática da','PRK','408');
INSERT INTO PAIS VALUES ('KR','CORÉIA DO SUL','Coréia do Sul','KOR','410');
INSERT INTO PAIS VALUES ('KW','KUWAIT','Kuwait','KWT','414');
INSERT INTO PAIS VALUES ('KG','QUIRGUISTÃO','Quirguistão','KGZ','417');
INSERT INTO PAIS VALUES ('LA','LAOS, REPÚBLICA DEMOCRÁTICA','Laos, República Democrática','LAO','418');
INSERT INTO PAIS VALUES ('LV','LETÔNIA','Letônia','LVA','428');
INSERT INTO PAIS VALUES ('LB','LÍBANO','Líbano','LBN','422');
INSERT INTO PAIS VALUES ('LS','LESOTHO','Lesotho','LSO','426');
INSERT INTO PAIS VALUES ('LR','LIBÉRIA','Libéria','LBR','430');
INSERT INTO PAIS VALUES ('LY','LÍBIA','Líbia','LBY','434');
INSERT INTO PAIS VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');
INSERT INTO PAIS VALUES ('LT','LITUÂNIA','Lituânia','LTU','440');
INSERT INTO PAIS VALUES ('LU','LUXEMBURGO','Luxemburgo','LUX','442');
INSERT INTO PAIS VALUES ('MO','MACAU','Macau','MAC','446');
INSERT INTO PAIS VALUES ('MK','MACEDÔNIA','Macedônia','MKD','807');
INSERT INTO PAIS VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');
INSERT INTO PAIS VALUES ('MW','MALAWI','Malawi','MWI','454');
INSERT INTO PAIS VALUES ('MY','MALÁSIA','Malásia','MYS','458');
INSERT INTO PAIS VALUES ('MV','MALDIVAS','Maldivas','MDV','462');
INSERT INTO PAIS VALUES ('ML','MALI','Mali','MLI','466');
INSERT INTO PAIS VALUES ('MT','MALTA','Malta','MLT','470');
INSERT INTO PAIS VALUES ('MH','ILHAS MARSHALL','Ilhas Marshall','MHL','584');
INSERT INTO PAIS VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');
INSERT INTO PAIS VALUES ('MR','MAURITÂNIA','Mauritânia','MRT','478');
INSERT INTO PAIS VALUES ('MU','MAURÍCIO','Maurício','MUS','480');
INSERT INTO PAIS VALUES ('YT','MAYOTTE','Mayotte', NULL, NULL);
INSERT INTO PAIS VALUES ('MX','MÉXICO','México','MEX','484');
INSERT INTO PAIS VALUES ('FM','MICRONÉSIA, ESTADOS FEDERADOS DA','Micronésia, Estados Federados da','FSM','583');
INSERT INTO PAIS VALUES ('MD','MOLDÁVIA, REPÚBLICA DA','Moldávia, República da','MDA','498');
INSERT INTO PAIS VALUES ('MC','MÔNACO','Mônaco','MCO','492');
INSERT INTO PAIS VALUES ('MN','MONGÓLIA','Mongólia','MNG','496');
INSERT INTO PAIS VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');
INSERT INTO PAIS VALUES ('MA','MARROCOS','Marrocos','Mar','504');
INSERT INTO PAIS VALUES ('MZ','MOÇAMBIQUE','Moçambique','MOZ','508');
INSERT INTO PAIS VALUES ('MM','MYANMAR','Myanmar','MMR','104');
INSERT INTO PAIS VALUES ('NA','NAMÍBIA','Namíbia','NAM','516');
INSERT INTO PAIS VALUES ('NR','NAURU','Nauru','NRU','520');
INSERT INTO PAIS VALUES ('NP','NEPAL','Nepal','NPL','524');
INSERT INTO PAIS VALUES ('NL','PAÍSES BAIXOS','Países Baixos','NLD','528');
INSERT INTO PAIS VALUES ('AN','ANTILHAS','Antilhas Holandesas','ANT','530');
INSERT INTO PAIS VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');
INSERT INTO PAIS VALUES ('NZ','NOVA ZELÂNDIA','Nova Zelândia','NZL','554');
INSERT INTO PAIS VALUES ('NI','NICARÁGUA','Nicarágua','NIC','558');
INSERT INTO PAIS VALUES ('NE','NÍGER','Niger','NER','562');
INSERT INTO PAIS VALUES ('NG','NIGÉRIA','Nigéria','NGA','566');
INSERT INTO PAIS VALUES ('NU','NIUE','Niue','NIU','570');
INSERT INTO PAIS VALUES ('NF','ILHA NORFOLK','Ilha Norfolk','NFK','574');
INSERT INTO PAIS VALUES ('MP','ILHAS MARIANAS DO NORTE','Ilhas Marianas do Norte','MNP','580');
INSERT INTO PAIS VALUES ('NO','NORUEGA','Noruega','NOR','578');
INSERT INTO PAIS VALUES ('OM','OMÃ','Omã','OMN','512');
INSERT INTO PAIS VALUES ('PK','PAQUISTÃO','Paquistão','PAK','586');
INSERT INTO PAIS VALUES ('PW','PALAU','Palau','PLW','585');
INSERT INTO PAIS VALUES ('PS','Palestina','Palestina', NULL, NULL);
INSERT INTO PAIS VALUES ('PA','PANAMÁ','Panamá','pan','591');
INSERT INTO PAIS VALUES ('PG','PAPUA NOVA GUINÉ','Papua-Nova Guiné','PNG','598');
INSERT INTO PAIS VALUES ('PY','PARAGUAI','Paraguai','PRY','600');
INSERT INTO PAIS VALUES ('PE','PERU','Peru','PER','604');
INSERT INTO PAIS VALUES ('PH','FILIPINAS','Filipinas','PHL','608');
INSERT INTO PAIS VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');
INSERT INTO PAIS VALUES ('PL','POLÔNIA','Polónia','POL','616');
INSERT INTO PAIS VALUES ('PT','PORTUGAL','Portugal','PRT','620');
INSERT INTO PAIS VALUES ('PR','PORTO RICO','Porto Rico','PRI','630');
INSERT INTO PAIS VALUES ('QA','QATAR','Qatar','QAT','634');
INSERT INTO PAIS VALUES ('RE','REUNIÃO','Reunion','REU','638');
INSERT INTO PAIS VALUES ('RO','ROMÊNIA','Romênia','ROM','642');
INSERT INTO PAIS VALUES ('RU','RÚSSIA','Rússia','RUS','643');
INSERT INTO PAIS VALUES ('RW','RUANDA','Ruanda','RWA','646');
INSERT INTO PAIS VALUES ('SH','SANTA HELENA','Santa Helena','SHN','654');
INSERT INTO PAIS VALUES ('KN','SÃO CRISTÓVÃO E NEVIS','São Cristóvão e Nevis','KNA','659');
INSERT INTO PAIS VALUES ('LC','SAINT LUCIA','Santa Lúcia','LCA','662');
INSERT INTO PAIS VALUES ('PM','SAINT PIERRE E MIQUELON','Saint Pierre e Miquelon','SPM','666');
INSERT INTO PAIS VALUES ('VC','SÃO VICENTE E GRANADINAS','São Vicente e Granadinas','VCT','670');
INSERT INTO PAIS VALUES ('WS','SAMOA','Samoa','WSM','882');
INSERT INTO PAIS VALUES ('SM','SAN MARINO','San Marino','SMR','674');
INSERT INTO PAIS VALUES ('ST','SÃO TOMÉ E PRÍNCIPE','São Tomé e Príncipe','STP','678');
INSERT INTO PAIS VALUES ('SA','ARÁBIA SAUDITA','Arábia Saudita','SAU','682');
INSERT INTO PAIS VALUES ('SN','SENEGAL','Senegal','NEE','686');
INSERT INTO PAIS VALUES ('CS','SÉRVIA E MONTENEGRO','a Sérvia e Montenegro', NULL, NULL);
INSERT INTO PAIS VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');
INSERT INTO PAIS VALUES ('SL','SERRA LEOA','Serra Leoa','LES','694');
INSERT INTO PAIS VALUES ('SG','SINGAPURA','Singapura','PEC','702');
INSERT INTO PAIS VALUES ('SK','ESLOVÁQUIA','Eslováquia','SVK','703');
INSERT INTO PAIS VALUES ('SI','ESLOVÊNIA','Eslovênia','SVN','705');
INSERT INTO PAIS VALUES ('SB','ILHAS SALOMÃO','Ilhas Salomão','SLB','090');
INSERT INTO PAIS VALUES ('SO','SOMÁLIA','Somália','SOM','706');
INSERT INTO PAIS VALUES ('ZA','ÁFRICA DO SUL','África do Sul','ZAF','710');
INSERT INTO PAIS VALUES ('GS','GEÓRGIA DO SUL E SANDWICH DO SUL','Geórgia do Sul e Sandwich do Sul', null, null);
INSERT INTO PAIS VALUES ('ES','ESPANHA','Espanha','ESP','724');
INSERT INTO PAIS VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');
INSERT INTO PAIS VALUES ('SD','SUDÃO','Sudão','SDN','736');
INSERT INTO PAIS VALUES ('SR','SURINAME','Suriname','SUR','740');
INSERT INTO PAIS VALUES ('SJ','SVALBARD E JAN MAYEN','Svalbard e Jan Mayen','SJM','744');
INSERT INTO PAIS VALUES ('SZ','SUAZILÂNDIA','Suazilândia','SWZ','748');
INSERT INTO PAIS VALUES ('SE','SUÉCIA','Suécia','SWE','752');
INSERT INTO PAIS VALUES ('CH','SUÍÇA','Suíça','che','756');
INSERT INTO PAIS VALUES ('SY','REPÚBLICA ÁRABE SÍRIA','República Árabe Síria','SYR','760');
INSERT INTO PAIS VALUES ('TW','TAIWAN, PROVÍNCIA DE CHINA','Taiwan, Província da China','TWN','158');
INSERT INTO PAIS VALUES ('TJ','TAJIQUISTÃO','Tajiquistão','TJK','762');
INSERT INTO PAIS VALUES ('TZ','TANZÂNIA, REPÚBLICA UNIDA','Tanzânia, República Unida da','TZA','834');
INSERT INTO PAIS VALUES ('TH','TAILÂNDIA','Tailândia','THA','764');
INSERT INTO PAIS VALUES ('TL','TIMOR-LESTE','Timor-Leste', NULL, NULL);
INSERT INTO PAIS VALUES ('TG','TOGO','Togo','TGO','768');
INSERT INTO PAIS VALUES ('TK','TOKELAU','Tokelau','TKL','772');
INSERT INTO PAIS VALUES ('TO','TONGA','Tonga','TON','776');
INSERT INTO PAIS VALUES ('TT','TRINIDAD E TOBAGO','Trinidad e Tobago','TTO','780');
INSERT INTO PAIS VALUES ('TN','TUNÍSIA','Tunísia','TUN','788');
INSERT INTO PAIS VALUES ('TR','TURQUIA','Turquia','TUR','792');
INSERT INTO PAIS VALUES ('TM','TURCOMENISTÃO','Turquemenistão','TKM','795');
INSERT INTO PAIS VALUES ('TC','ILHAS TURKS E CAICOS','Ilhas Turcas e Caicos','TCA','796');
INSERT INTO PAIS VALUES ('TV','TUVALU','Tuvalu','TUV','798');
INSERT INTO PAIS VALUES ('UG','UGANDA','Uganda','UGA','800');
INSERT INTO PAIS VALUES ('UA','UCRÂNIA','Ucrânia','UKR','804');
INSERT INTO PAIS VALUES ('AE','EMIRADOS ÁRABES UNIDOS','Emirados Árabes Unidos','Tem','784');
INSERT INTO PAIS VALUES ('GB','REINO UNIDO','Reino Unido','GBR','826');
INSERT INTO PAIS VALUES ('US','ESTADOS UNIDOS','Estados Unidos','EUA','840');
INSERT INTO PAIS VALUES ('UM','ESTADOS UNIDOS ILHAS MENORES DISTANTES','Estados Unidos Ilhas Menores Distantes', null, null);
INSERT INTO PAIS VALUES ('UY','URUGUAI','Uruguai','URY','858');
INSERT INTO PAIS VALUES ('UZ','UZBEQUISTÃO','Uzbequistão','UZB','860');
INSERT INTO PAIS VALUES ('VU','VANUATU','Vanuatu','VUT','548');
INSERT INTO PAIS VALUES ('VE','VENEZUELA','Venezuela','VEN','862');
INSERT INTO PAIS VALUES ('VN','VIETNÃ','Vietnã','VNM','704');
INSERT INTO PAIS VALUES ('VG','ILHAS VIRGENS BRITÂNICAS','Ilhas Virgens Britânicas','VGB','092');
INSERT INTO PAIS VALUES ('VI','ILHAS VIRGENS, EUA','Ilhas Virgens, EUA','VIR','850');
INSERT INTO PAIS VALUES ('WF','WALLIS E FUTUNA','Wallis e Futuna','WLF','876');
INSERT INTO PAIS VALUES ('EH','SAHARA OCIDENTAL','Sahara Ocidental','ESH','732');
INSERT INTO PAIS VALUES ('YE','IÊMEN','Iêmen','YEM','887');
INSERT INTO PAIS VALUES ('ZM','ZÂMBIA','Zâmbia','ZMB','894');
INSERT INTO PAIS VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');