http://springboardsolutions.com/wiki/index.php?action=history&feed=atom&title=Example_Country_Table 2026-10-17T02:40:38Z Revision history for this page on the wiki MediaWiki 1.25.2 http://springboardsolutions.com/wiki/index.php?title=Example_Country_Table&diff=189&oldid=prev 2016-03-25T08:51:07Z

<p>1 revision imported</p> <table class='diff diff-contentalign-left'> <tr style='vertical-align: top;'> <td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 08:51, 25 March 2016</td> </tr><tr><td colspan='2' style='text-align: center;'><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

WikiSysop http://springboardsolutions.com/wiki/index.php?title=Example_Country_Table&diff=187&oldid=prev 2011-08-15T20:42:00Z

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

WikiSysop