|
The following script can be used to populate a lookup for use in ETL or, with a bit of modification, a currency dimension for use in your warehouse.
Assumes two column table with code and description columns.
The script contains the most commonly used 3 character ISO currency codes. Obsolete currencies such as FRF (French Franc) and DEM (Deutschemark) - both now replaced by the Euro - are not included. If you need these for historical data, you are going to have to add to the list manually or find yourself another load script
Sorry! 
insert into currency_codes values ('AED', 'UAE dirham');
insert into currency_codes values ('AFA', 'Afghanistan afghani');
insert into currency_codes values ('ALL', 'Albanian lek');
insert into currency_codes values ('AMD', 'Armenian dram');
insert into currency_codes values ('ANG', 'Netherlands Antillian guilder');
insert into currency_codes values ('AOR', 'Angolan kwanza reajustado');
insert into currency_codes values ('ARS', 'Argentine peso');
insert into currency_codes values ('AUD', 'Australian dollar');
insert into currency_codes values ('AWG', 'Aruban guilder');
insert into currency_codes values ('AZN', 'Azerbaijanian new manat');
insert into currency_codes values ('BBD', 'Barbados dollar');
insert into currency_codes values ('BDT', 'Bangladeshi taka');
insert into currency_codes values ('BGN', 'Bulgarian lev');
insert into currency_codes values ('BHD', 'Bahraini dinar');
insert into currency_codes values ('BIF', 'Burundi franc');
insert into currency_codes values ('BMD', 'Bermudian dollar');
insert into currency_codes values ('BND', 'Brunei dollar');
insert into currency_codes values ('BOB', 'Bolivian boliviano');
insert into currency_codes values ('BRL', 'Brazilian real');
insert into currency_codes values ('BSD', 'Bahamian dollar');
insert into currency_codes values ('BTN', 'Bhutan ngultrum');
insert into currency_codes values ('BWP', 'Botswana pula');
insert into currency_codes values ('BYR', 'Belarusian ruble');
insert into currency_codes values ('BZD', 'Belize dollar');
insert into currency_codes values ('CAD', 'Canadian dollar');
insert into currency_codes values ('CDF', 'Congolese franc');
insert into currency_codes values ('CHF', 'Swiss franc');
insert into currency_codes values ('CLP', 'Chilean peso');
insert into currency_codes values ('CNY', 'Chinese yuan renminbi');
insert into currency_codes values ('COP', 'Colombian peso');
insert into currency_codes values ('CRC', 'Costa Rican colon');
insert into currency_codes values ('CUP', 'Cuban peso');
insert into currency_codes values ('CVE', 'Cape Verde escudo');
insert into currency_codes values ('CYP', 'Cypriot pound');
insert into currency_codes values ('CZK', 'Czech koruna');
insert into currency_codes values ('DJF', 'Djibouti franc');
insert into currency_codes values ('DKK', 'Danish krone');
insert into currency_codes values ('DOP', 'Dominican peso');
insert into currency_codes values ('DZD', 'Algerian dinar');
insert into currency_codes values ('EEK', 'Estonian kroon');
insert into currency_codes values ('EGP', 'Egyptian pound');
insert into currency_codes values ('ERN', 'Eritrean nakfa');
insert into currency_codes values ('ETB', 'Ethiopian birr');
insert into currency_codes values ('EUR', 'EU euro');
insert into currency_codes values ('FJD', 'Fiji dollar');
insert into currency_codes values ('FKP', 'Falkland Islands pound');
insert into currency_codes values ('GBP', 'British pound');
insert into currency_codes values ('GEL', 'Georgian lari');
insert into currency_codes values ('GHS', 'Ghanaian new cedi');
insert into currency_codes values ('GIP', 'Gibraltar pound');
insert into currency_codes values ('GMD', 'Gambian dalasi');
insert into currency_codes values ('GNF', 'Guinean franc');
insert into currency_codes values ('GTQ', 'Guatemalan quetzal');
insert into currency_codes values ('GYD', 'Guyana dollar');
insert into currency_codes values ('HKD', 'Hong Kong SAR dollar');
insert into currency_codes values ('HNL', 'Honduran lempira');
insert into currency_codes values ('HRK', 'Croatian kuna');
insert into currency_codes values ('HTG', 'Haitian gourde');
insert into currency_codes values ('HUF', 'Hungarian forint');
insert into currency_codes values ('IDR', 'Indonesian rupiah');
insert into currency_codes values ('ILS', 'Israeli new shekel');
insert into currency_codes values ('INR', 'Indian rupee');
insert into currency_codes values ('IQD', 'Iraqi dinar');
insert into currency_codes values ('IRR', 'Iranian rial');
insert into currency_codes values ('ISK', 'Icelandic krona');
insert into currency_codes values ('JMD', 'Jamaican dollar');
insert into currency_codes values ('JOD', 'Jordanian dinar');
insert into currency_codes values ('JPY', 'Japanese yen');
insert into currency_codes values ('KES', 'Kenyan shilling');
insert into currency_codes values ('KGS', 'Kyrgyz som');
insert into currency_codes values ('KHR', 'Cambodian riel');
insert into currency_codes values ('KMF', 'Comoros franc');
insert into currency_codes values ('KPW', 'North Korean won');
insert into currency_codes values ('KRW', 'South Korean won');
insert into currency_codes values ('KWD', 'Kuwaiti dinar');
insert into currency_codes values ('KYD', 'Cayman Islands dollar');
insert into currency_codes values ('KZT', 'Kazakh tenge');
insert into currency_codes values ('LAK', 'Lao kip');
insert into currency_codes values ('LBP', 'Lebanese pound');
insert into currency_codes values ('LKR', 'Sri Lanka rupee');
insert into currency_codes values ('LRD', 'Liberian dollar');
insert into currency_codes values ('LSL', 'Lesotho loti');
insert into currency_codes values ('LTL', 'Lithuanian litas');
insert into currency_codes values ('LVL', 'Latvian lats');
insert into currency_codes values ('LYD', 'Libyan dinar');
insert into currency_codes values ('MAD', 'Moroccan dirham');
insert into currency_codes values ('MDL', 'Moldovan leu');
insert into currency_codes values ('MGA', 'Malagasy ariary');
insert into currency_codes values ('MKD', 'Macedonian denar');
insert into currency_codes values ('MMK', 'Myanmar kyat');
insert into currency_codes values ('MNT', 'Mongolian tugrik');
insert into currency_codes values ('MOP', 'Macao SAR pataca');
insert into currency_codes values ('MRO', 'Mauritanian ouguiya');
insert into currency_codes values ('MTL', 'Maltese lira');
insert into currency_codes values ('MUR', 'Mauritius rupee');
insert into currency_codes values ('MVR', 'Maldivian rufiyaa');
insert into currency_codes values ('MWK', 'Malawi kwacha');
insert into currency_codes values ('MXN', 'Mexican peso');
insert into currency_codes values ('MYR', 'Malaysian ringgit');
insert into currency_codes values ('MZN', 'Mozambique new metical');
insert into currency_codes values ('NAD', 'Namibian dollar');
insert into currency_codes values ('NGN', 'Nigerian naira');
insert into currency_codes values ('NIO', 'Nicaraguan cordoba oro');
insert into currency_codes values ('NOK', 'Norwegian krone');
insert into currency_codes values ('NPR', 'Nepalese rupee');
insert into currency_codes values ('NZD', 'New Zealand dollar');
insert into currency_codes values ('OMR', 'Omani rial');
insert into currency_codes values ('PAB', 'Panamanian balboa');
insert into currency_codes values ('PEN', 'Peruvian nuevo sol');
insert into currency_codes values ('PGK', 'Papua New Guinea kina');
insert into currency_codes values ('PHP', 'Philippine peso');
insert into currency_codes values ('PKR', 'Pakistani rupee');
insert into currency_codes values ('PLN', 'Polish zloty');
insert into currency_codes values ('PYG', 'Paraguayan guarani');
insert into currency_codes values ('QAR', 'Qatari rial');
insert into currency_codes values ('RON', 'Romanian new leu');
insert into currency_codes values ('RSD', 'Serbian dinar');
insert into currency_codes values ('RUB', 'Russian ruble');
insert into currency_codes values ('RWF', 'Rwandan franc');
insert into currency_codes values ('SAR', 'Saudi riyal');
insert into currency_codes values ('SBD', 'Solomon Islands dollar');
insert into currency_codes values ('SCR', 'Seychelles rupee');
insert into currency_codes values ('SDG', 'Sudanese pound');
insert into currency_codes values ('SEK', 'Swedish krona');
insert into currency_codes values ('SGD', 'Singapore dollar');
insert into currency_codes values ('SHP', 'Saint Helena pound');
insert into currency_codes values ('SKK', 'Slovak koruna');
insert into currency_codes values ('SLL', 'Sierra Leone leone');
insert into currency_codes values ('SOS', 'Somali shilling');
insert into currency_codes values ('SRD', 'Suriname dollar');
insert into currency_codes values ('STD', 'Sao Tome and Principe dobra');
insert into currency_codes values ('SVC', 'El Salvador colon');
insert into currency_codes values ('SYP', 'Syrian pound');
insert into currency_codes values ('SZL', 'Swaziland lilangeni');
insert into currency_codes values ('THB', 'Thai baht');
insert into currency_codes values ('TJS', 'Tajik somoni');
insert into currency_codes values ('TMM', 'Turkmen manat');
insert into currency_codes values ('TND', 'Tunisian dinar');
insert into currency_codes values ('TOP', 'Tongan pa'anga');
insert into currency_codes values ('TRY', 'Turkish lira');
insert into currency_codes values ('TTD', 'Trinidad and Tobago dollar');
insert into currency_codes values ('TWD', 'Taiwan New dollar');
insert into currency_codes values ('TZS', 'Tanzanian shilling');
insert into currency_codes values ('UAH', 'Ukrainian hryvnia');
insert into currency_codes values ('UGX', 'Uganda new shilling');
insert into currency_codes values ('USD', 'US dollar');
insert into currency_codes values ('UYU', 'Uruguayan peso uruguayo');
insert into currency_codes values ('UZS', 'Uzbekistani sum');
insert into currency_codes values ('VEB', 'Venezuelan bolivar');
insert into currency_codes values ('VND', 'Vietnamese dong');
insert into currency_codes values ('VUV', 'Vanuatu vatu');
insert into currency_codes values ('WST', 'Samoan tala');
insert into currency_codes values ('XAF', 'CFA franc BEAC');
insert into currency_codes values ('XAG', 'Silver (ounce)');
insert into currency_codes values ('XAU', 'Gold (ounce)');
insert into currency_codes values ('XCD', 'East Caribbean dollar');
insert into currency_codes values ('XDR', 'IMF special drawing right');
insert into currency_codes values ('XFO', 'Gold franc');
insert into currency_codes values ('XFU', 'UIC franc');
insert into currency_codes values ('XOF', 'CFA franc BCEAO');
insert into currency_codes values ('XPD', 'Palladium (ounce)');
insert into currency_codes values ('XPF', 'CFP franc ');
insert into currency_codes values ('XPT', 'Platinum (ounce)');
insert into currency_codes values ('YER', 'Yemeni rial');
insert into currency_codes values ('ZAR', 'South African rand');
insert into currency_codes values ('ZMK', 'Zambian kwacha');
insert into currency_codes values ('ZWD', 'Zimbabwe dollar');
commit; |
